Re: analyze index and cost

From: santosh sharma <santysharma_at_yahoo.com>
Date: Thu, 28 Feb 2002 17:17:17 -0800
Message-ID: <a5ml0f$8mgec$1@ID-84096.news.dfncis.de>

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 Thu Feb 28 2002 - 19:17:17 CST