-- Oracle 12c: Analysis of database objects (table, index,..) ANALYZE TABLE table_name delete statistics ; ANALYZE TABLE table_name estimate statistics sample 10 percent for table_name for all indexes for all indexed columns ; ANALYZE TABLE table_name VALIDATE STRUCTURE ; -- Analyze table and all indexes ANALYZE TABLE table_name VALIDATE STRUCTURE CASCADE ; -- Analyze table and check ROWID ANALYZE TABLE table_name VALIDATE REF UPDATE ; -- Analyze table in live mode (during DML activities) ANALYZE TABLE table_name VALIDATE STRUCTURE ONLINE ; -- The chained_rows table has to be created first -- For Non-Index Organized Tables tables -- UTLCHAIN.SQL -- For Index Organized Tables (IOT) and conventional tables -- UTLCHN1.SQL ANALYZE TABLE table_name LIST CHAINED ROWS INTO chained_rows ; SELECT * FROM chained_rows ; ANALYZE CLUSTER cluster_name VALIDATE STRUCTURE CASCADE ;
9874