| Subject | Re: [firebird-support] 3rd Request for Help - How can optimize and speed up this query? (Database Workbench) |
|---|---|
| Author | Douglas Tosi |
| Post date | 2008-12-27T19:20:35Z |
On Sat, Dec 27, 2008 at 11:45 AM, SoftTech <miket@...> wrote:
metadata it's hard to come up with a solution.
Is there an index in T.TRAN_ID?
If there is, try placing an index in AT1.TRAN_DATE or AT1.NEXT_RUN_DATE.
What is the approximate record count of each involved table?
What is the selectivity of the indexes that appear in the plan?
What other indexes are present in the involved tables?
hth,
--
Douglas Tosi
www.sinatica.com
> PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (T NATURAL,ATM INDEXThis is more of a guess. Without more information about your data and
> (REFTE_TRAN259),AT1 INDEX (REFACCT_TRAN_MASTER777)),TP INDEX
> (PK_TE_PLAN_TRAN)),ATQS INDEX (PK_ACCT_TRAN_QUE_STATUS)),ATQS2 INDEX
> (PK_ACCT_TRAN_QUE_STATUS)),ATQS3 INDEX (PK_ACCT_TRAN_QUE_STATUS)))
metadata it's hard to come up with a solution.
Is there an index in T.TRAN_ID?
If there is, try placing an index in AT1.TRAN_DATE or AT1.NEXT_RUN_DATE.
What is the approximate record count of each involved table?
What is the selectivity of the indexes that appear in the plan?
What other indexes are present in the involved tables?
hth,
--
Douglas Tosi
www.sinatica.com