-
Please help me analyze the explain plan:
Here is the explain plan:
SELECT STATEMENT COST=15781
VIEW ORDER_DATA
UNION-ALL
TABLE ACCESS BY INDEX ROWID INTRA_DAY_ORDER_BOOK
INDEX FULL SCAN INTRA_DAY_ORDER_BOOK_IDX2
FILTER
TABLE ACCESS BY INDEX ROWID INBOUND_ORDER
INDEX RANGE SCAN INBOUND_ORDER_IDX2
INDEX RANGE SCAN INTRA_DAY_ORDER_BOOK_IDX3
Q: WHAT is a INDEX FULL SCAN and how can I avoid it ?
-
Okay, 2 things.
1) I can't tell if you are selecting the plan in the correct order or not. Just in case, run a query that looks like:
SELECT
---LPAD('-',3*(LEVEL-1))||PT.OPERATION||' '||PT.OPTIONS||' '||PT.OBJECT_NAME AS FormattedText,
---PT.COST, PT.CARDINALITY, PT.BYTES
FROM
---PLAN_TABLE PT
START WITH
---ID = 0 AND
---STATEMENT_ID = 'WHATEVER'
CONNECT BY
---PRIOR ID = PARENT_ID AND
---STATEMENT_ID = 'WHATEVER'
to get the output. KEEP the daashes, as everything is left-justified in this forum - spaces are eliminated.
Then we'll have a better shot at reading the plan
2) Include the original statement. Kind of hard to pick apart a plan in isolation. With the statement, at least we have a shot to see what you might be doing.
- Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|