Re: analyze index and cost

Howard,

  How do you revert back says analyze .. compute statistics is bad? If that is the case what is the point of analyzing some tables or indexes with a view to provide better stats. Oracle may not use it at all!

  I always thought that at all times, I should do analyze to make it run faster!

Allan W. Tham
Oracle DBA

>>All I wanted to point out here is that computing statistics does NOT mean
>>'things go faster', it means that the optimizer has some basis on which to
>>work out an *intelligent* approach to getting at the data, rather than just
>>blindly following a set of 15 rules that haven't changed in years. Usually
>>that *would* mean performance improvements, but there are plenty of
>>configuration and coding issues which can stop that happening. They need to
>>be diagnosed and resolved -and that simply can't be done in the absence of
>>any further information from you.
Received on Sun Mar 03 2002 - 23:48:22 CST