Топ-100
 

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

ANALYZE
{ { TABLE [ schema. ] table
| INDEX [ schema. ] index
} [ partition_extension_clause ]
| CLUSTER [ schema. ] cluster
}
{ validation_clauses
| LIST CHAINED ROWS [ into_clause ]
| DELETE [ SYSTEM ] STATISTICS
} ;

partition_extension_clause::=
{ PARTITION (partition)
| PARTITION FOR (partition_key_value [, partition_key_value]...)
| SUBPARTITION (subpartition)
| SUBPARTITION FOR (subpartition_key_value [, subpartition_key_value]...)
}
validation_clauses::=
{ VALIDATE REF UPDATE [ SET DANGLING TO NULL ]
| VALIDATE STRUCTURE
[ CASCADE { FAST | COMPLETE { OFFLINE | ONLINE } [ into_clause ] } ]
}
into_clause::=
INTO [ schema. ] table

Example

ANALYZE TABLE orders DELETE STATISTICS;

ANALYZE INDEX inv_product_ix VALIDATE STRUCTURE;

ANALYZE TABLE employees VALIDATE STRUCTURE CASCADE;

ANALYZE TABLE customers VALIDATE REF UPDATE;

ANALYZE TABLE customers VALIDATE STRUCTURE ONLINE;

ANALYZE CLUSTER personnel VALIDATE STRUCTURE CASCADE;

ANALYZE TABLE orders LIST CHAINED ROWS INTO chained_rows;