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

Revision #2
Created Wed, Jul 17, 2019 11:18 PM by PeopleSoft Wiki
Updated Wed, Jul 17, 2019 11:18 PM by PeopleSoft Wiki