Home » RDBMS Server » Performance Tuning » explain plan
explain plan [message #65305] Wed, 28 July 2004 20:20 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
Dear All,

I have a SQL query, whose explain plan is shown below. Can you please let me know, whether the following explain plan is a good plan or not? if not then where is the problem.

SELECT STATEMENT, GOAL = CHOOSE      
 SORT GROUP BY      0
  NESTED LOOPS      1
   NESTED LOOPS      2
    NESTED LOOPS      3
     NESTED LOOPS      4
      TABLE ACCESS BY INDEX ROWID JAY T_CLAIM    5
       INDEX RANGE SCAN JAY JKN_T_CLAIM    6
      TABLE ACCESS BY INDEX ROWID JAY T_CLAIM_BASE    5
       INDEX UNIQUE SCAN JAY PK_T_CLAIM_BASE    8
     TABLE ACCESS BY INDEX ROWID JAY T_POLICY_BASE    4
      INDEX UNIQUE SCAN JAY PK_T_POLICY_BASE    10
    TABLE ACCESS BY INDEX ROWID JAY T_CLAIM_INSTALLMENT    3
     INDEX RANGE SCAN JAY JKN_T_CLAIM_INSTALLMENT    12
   TABLE ACCESS BY INDEX ROWID JAY T_CLAIM_DETAILS_BASE    2
    INDEX UNIQUE SCAN JAY PK_T_CLAIM_DETAILS_BASE    14

Hope you will let me know.

Thanks,

Jay.
Re: explain plan [message #65308 is a reply to message #65305] Thu, 29 July 2004 05:23 Go to previous messageGo to next message
shoblock
Messages: 325
Registered: April 2004
Senior Member
without actually knowing the actual sql, the number of records in each table, whether the indexes used are on joined columns or comparisons to variables (scalars), and many other things, I'll say "sure, it looks good"

The real question to you is: how does it perform? Elapsed time is much more meaningful than an explain plan, the cost, or any other info provided by sqltrace. After all, if it's fast, who cares about anything else!
Re: explain plan [message #65317 is a reply to message #65305] Fri, 30 July 2004 21:30 Go to previous message
Shubhkaran
Messages: 2
Registered: July 2004
Junior Member
Give the detail of types of indexes you have used and also the sql statement
Previous Topic: Understanding the Information Contained in the Parameter Box
Next Topic: RAID
Goto Forum:
  


Current Time: Sun Dec 22 23:10:00 CST 2024