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

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Tue, 22 Sep 2009 13:05:39 -0700 (PDT)
Message-ID: <e25d799b-5a41-4728-a1a3-b066acb0176e_at_o36g2000vbl.googlegroups.com>



On Sep 22, 6:07 am, UXDBA <unixdb..._at_googlemail.com> wrote:

snip

> All,
>
> 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

You can try it on a test system ... or in 11g play around making the index invisible and then visible again. Received on Tue Sep 22 2009 - 15:05:39 CDT

Original text of this message