|
-
Hi oracle guru's
Please help me in tuning SQL statement. The details of indexes on table and results of Explain plan are :
INDEX DETAILS :
INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
IND_WLDT_APPDT APP_DATE 1
IND_WLDT_BC BILLCYCLE 1
IND_WLDT_COLAGE COL_AGING 1
IND_WLDT_PRG PRGCODE 1
IND_WLDT_SER SERVICE 1
IND_WLDT_STATUS STATUS 1
IND_WLDT_SVRAGE SVR_AGING 1
WD_PK BILLCYCLE 1
WD_PK APP_DATE 2
WD_PK SERVICE 3
WD_PK CUSTCODE 4
PLAN STATEMENT :
COLUMN plan FORMAT a70
SELECT lpad(' ', 3*level)||operation||'('||options||')
'||object_name||
' ' ||object_type plan
FROM plan_table
CONNECT BY PRIOR id = parent_id and statement_id='STMT1'
START WITH id = 1 and statement_id = 'STMT1';
PLAN RESULTS :
PLAN
----------------------------------------------------------------------
TABLE ACCESS(BY INDEX ROWID)
WL_DETAILS
INDEX(RANGE SCAN)
WD_PK UNIQUE
SORT(AGGREGATE)
INDEX(RANGE SCAN)
WD_PK UNIQUE
PLAN
----------------------------------------------------------------------
Please Help in tuning the above statement.
Thanks In Advance.
Nagesh
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
|