10g explain plan detemination without actually doing change in the query...

I would like to know

in Oracle 10.2.0.4:
if I have below SQL:

select col1,col2 from t where col1=? and col3?

col13 & col1 both are indexed.

This query will have certain execution plan.

Now if I make alteration on col3 index . i.e. I drop the index on col3

Then I may have different exectuin plan of the query.

Question :

Is it poosible to find out in 10g to know what execution plan query will have after dropping index WITHOUT actually dropping the index?

Regards Received on Tue Sep 22 2009 - 05:07:34 CDT