Query Perfomance

[hrishy]

Hi Chuck

Can you analyze your tables involved in this query like this and let us know whether anything changed with the plan.


exec dbms_stats.gather_table_stats('USERNAME','TABLE_NAME',CASCADE=>TRUE,ESTIMATE_PERCENT=>15);

regards
Hrishy

[tamilselvan]

====
That's a crazy assertion when you don't even know what the problematic query is.

Also, you probably mean "if it's equivalent to the number of rows", not blocks.


__________________

===
Slimdave,
You are right. I made a mistake while typing.
My point is: If the table is disorganized, then probably the optimizer may not choose INDEX access path.

Tamil

[Chucks_k]

Hi all,

I have got it to work thanks to hrishys advice of using dbms_stats.gather_table_stats. I dont understand why when using this it picked up the index and not when i analyzed using dbms_utility?. Thank u all for yer valuable contributions, it has helped immensely.

Thanks once again,
Chucks.