10g explain plan detemination without actually doing change in the query...
Date: Tue, 22 Sep 2009 03:07:34 -0700 (PDT)
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.
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