Re: analyze index and cost

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Fri, 01 Mar 2002 16:22:58 GMT
Message-ID: <3C7FAAE9.C3F26803@ci.seattle.wa.us>

Excellent advise. If that doesn't solve it post the query, the explain plan, a list of indexes on the table(s), and the number of rows.

Are you using any hints?

Daniel Morgan

santosh sharma wrote:

> did you compare the explain plan before and after compute stat ? It will
> point you why this is happening.
>
> HTh
> santysharma
>
> "achkar" <kachkar_at_tablimited.com.au> wrote in message
> news:acb78eab.0202281707.34303a16_at_posting.google.com...
> > Hi All ,
> >
> > I have a big query , it takes 70 min to run , cost is 94819 , when I
> > create and index ( XXX ) on one of the tables , the cost drops down to
> > 53770 and takes 30 min to run , but when I do this : analyze index XXX
> > compute statistics , the cost goes up to 94819 again , I dont
> > understand why?
> >
> > thanks in advance
Received on Fri Mar 01 2002 - 10:22:58 CST