Re: Analyze vs dbms_stats

News wrote:
> someone to confirm that :
>
> - analyze is more suited to RBO and both wont be supported any more ?
>
> - in 10g one should use dbms_stats package instead ? stats generated
> are more accurate and plans could be different ?
>
> - what's exactly the difference between the 2 methods ?

1 RBO is about heuristics and doesn't use statistics at all. In 10g RBO is present but deprecated and ANALYZE is in the same boat. 2 yes, as documented and as documented
3 One thing is that ANALYZE won't use multiple processors and dbms_stats will.
ANALYZE can't retain old staticstics, dbms_stats can. Dbms_stats can override statistics, ANALYZE can't. Etc, etc,etc, etc and all documented

-- 
Sybrand Bakker
Senior Oracle DBA