Re: 10053 Interpretation....

> Are you sure it's going through the psDtl index,
> the trace file seems to be saying that it's going to
> use the psCtl index.

Yes I am,

Here is the bottom of the 10053:

Join order[1]: PS_TL_PAYABLE_TIME[A]#0
Best so far: TABLE#: 0 CST: 5 CDN: 74 BYTES: 1406
prefetching is on for PSDTL_PAYABLE_TIME Final - All Rows Plan:
  JOIN ORDER: 1
  CST: 5 CDN: 74 RSC: 5 RSP: 5 BYTES: 1406   IO-RSC: 5 IO-RSP: 5 CPU-RSC: 0 CPU-RSP: 0 QUERY
explain plan for
select count(*)
from

   PS_TL_PAYABLE_TIME A
WHERE
           A.DUR BETWEEN TO_DATE('2006-03-29','YYYY-MM-DD') AND TO_DATE('2006-03-31','YYYY-MM-DD')

AND        A.SETID_DEPT = 'TMMF_'
AND        A.TRC = 'C3'

PLAN
Cost of plan: 5
Operation...........Object name.....Options.........Id...Pid..

SELECT STATEMENT                                        0
SORT                                AGGREGATE           1
TABLE ACCESS        PS_TL_PAYABLE_TI BY INDEX ROWID      2    1
INDEX               PSDTL_PAYABLE_TI SKIP SCAN           3    2

the 10053 says: BEST_CST: 5.00 PATH: 4 Degree: 1

but I've never been able to correlate the PATH number (i.e. 4) with the evaluated PATHs.

Matt Received on Wed Mar 29 2006 - 08:17:26 CST