Re: Estimate statistics

Louis Felder wrote:
>
> I have heard rumors that there is a bug in the esitmate statistics part
> of analyze table in versions of Oracle prior to 7.2 Is there any truth
> to the rumor? If it is true, does anyone know of a work around other
> than doing a compute statistics?
>
> TIA
> Lou

Yes, there are several bugs with analyze even in 7.2. However, depending which problem you are encountering there are different work-arounds. The best method is to use 'compute'. However, this is also buggy for very large tables (> 6 Gb) so that you can't use compute at all. Then, the only work around is to estimate with approximate 25-30% and do manual updates to the tab$ table to have correct stats. If you need more information you can e-mail me directly. It is not simple and the best choice is probably to use RULE based optimization.

check out our web site and utilities at
http://dbghome.computek.net

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->