Help w/ Explain Plan
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help w/ Explain Plan

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Unhappy

    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 ?

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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
  •  


Click Here to Expand Forum to Full Width