Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Anlayze Table Command
- Thread starter amolso
- Start date
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.
- Status
Similar threads
- Locked
- Question