O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Notes

You must own the object to be analyzed or have the ANALYZE ANY privilege to issue this command. If you want to use the LIST CHAINED ROWS operation to list into a table, that table must be in your schema or you must have the INSERT privilege on it. COMPUTE STATISTICS will result in more accurate statistics, but is likely to take longer. ESTIMATE STATISTICS will normally be much faster and almost as accurate. Note that the object being analyzed will be locked while statistics are being collected, so the faster ESTIMATE STATISTICS may be preferable in a heavy transaction environment. Statistics are stored in the DBA_TABLES data dictionary view, and some column statistics are stored in the DBA_TAB_COLUMNS data dictionary view.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required