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

From: UXDBA <unixdba73_at_googlemail.com>
Date: Tue, 22 Sep 2009 03:07:34 -0700 (PDT)
Message-ID: <3c825a76-5b56-4c82-afe7-981b93723d67_at_p36g2000vbn.googlegroups.com>


I would like to know

in Oracle
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

Original text of this message