The difference is what you might expect based on the syntax of the command. "Estimate statistics" generates table statistics based on a subset of the table rows. "Compute statistics" looks at all the rows. Estimate is faster but less accurate. [sig][/sig]
Depending on what level of Oracle you are using and whether you have row chaining, you may want to use 'compute statistics'. I have recently had errors occur both on 8.0.5.1 and 8.1.5.0 for large tables (over 15 million rows) and small tables with chained rows. The 'estimate statistics' gives a trace file and ends the 'analyze' command but the 'compute statistics' works. It is always better to do the 'compute' anyway, if you have the window.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.