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

From: UXDBA <unixdba73_at_googlemail.com>
Date: Wed, 23 Sep 2009 11:31:09 -0700 (PDT)
Message-ID: <c1641a07-117a-4661-9978-b8fa97cb16a0_at_o36g2000vbl.googlegroups.com>

On Sep 22, 9:05 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -

Many thanks all. Received on Wed Sep 23 2009 - 13:31:09 CDT