Why Oracle did not use my index?
Hi All,
I had faced a problem with one of our sql statement.It is a select statement to a multiple partition table.
These tables have indexes created.But somehow in the explain plan these indexes is not used.
Last month, the statement works fine, but unfortunately it is not being used this month.
I already executed dbms stats to gather latest statistics to the tables and indexes.
I tried to use hint to the select statement to use the indexes but also failed.
What I did was to drop and create back the indexes but also failed.The optimizer used was choose.
I had faced a problem with one of our sql statement.It is a select statement to a multiple partition table.
These tables have indexes created.But somehow in the explain plan these indexes is not used.
Last month, the statement works fine, but unfortunately it is not being used this month.
I already executed dbms stats to gather latest statistics to the tables and indexes.
I tried to use hint to the select statement to use the indexes but also failed.
What I did was to drop and create back the indexes but also failed.The optimizer used was choose.
0