Oracle statistics

EXEC DBMS_UTILITY.analyze_schema('schema_name','COMPUTE')

ANALYZE cluster clusterName compute statistics;
ANALYZE table tableName {compute|estimate|delete) statistics options
ANALYZE index indexName {compute|estimate|delete) statistics options
ANALYZE cluster clusterName {compute|estimate|delete) statistics options

Comments

Popular posts from this blog

Oracle JDBC ReadTimeout QueryTimeout

Generically load enum mapping via properties file