Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to optimize query's execution?
How to optimize query's execution? By using hints? Here is execution plan
for statement returning 3390 records in about 10 sec:
Execution Plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (ORDER BY)
2 1 TABLE ACCESS (BY INDEX ROWID) OF 'MY_KEYS' 3 2 NESTED LOOPS 4 3 TABLE ACCESS (BY INDEX ROWID) OF 'MY_STATE' 5 4 INDEX (RANGE SCAN) OF 'MY_STATE' (NON-UNIQUE) 6 3 INDEX (RANGE SCAN) OF 'MY_KEYS_IDX' (NON-UNIQUE)
What can be done? Received on Tue Aug 30 2005 - 07:57:07 CDT
![]() |
![]() |