Analyze Tables

You can use the ANALYZE TABLE command to store table statistics for Oracle (and many other DBMS) execution plans. A simple version of this script involves estimating statistics using the command:

analyze table 'TABLE_NAME' estimate statistics
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License