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