Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to optimize query's execution?

How to optimize query's execution?

From: uf <uf_at_one.com>
Date: Tue, 30 Aug 2005 14:57:07 +0200
Message-ID: <df1l34$ai6$1@domitilla.aioe.org>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US