Re: Wrong index being used ... Basic SQL Qs


3 Blocks on  the Index Range Scan in 65 microseconds.  Returning 0 rows.

Is that SQL really the query that you run in the Benchmark ?

Hemant

At 05:12 PM Tuesday, VIVEK_SHARMA wrote:

Folks
During an Internal Benchmark Run, following SQL Query is using the Wrong index idx_inst_num which has very Low Cardinality.ALL Rows of the Table have inst_num value = '89651' (1 Constant Value). 

<deleted>

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  SORT AGGREGATE (cr=3 pr=0 pw=0 time=87 us)
0 TABLE ACCESS BY GLOBAL INDEX ROWID INW_CLG_INST_TABLE PARTITION: 2 2 (cr=3 pr=0 p 
w=0 time=70 us)
0 INDEX RANGE SCAN IDX_INST_NUM (cr=3 pr=0 pw=0 time=65 us)(object id 28758) 


Hemant K Chitale
http://hemantoracledba.blogspot.com
"First they ignore you, then they laugh at you, then they fight you, then you win" !" Mohandas Gandhi Quotes : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: