LucidDbAnalyzeTable

From Eigenpedia

Syntax

ANALYZE TABLE qualified-table-name
COMPUTE STATISTICS FOR { ALL COLUMNS | COLUMNS ( unqualified-column-name, ... ) }

ANALYZE TABLE qualified-table-name
ESTIMATE STATISTICS FOR { ALL COLUMNS | COLUMNS ( unqualified-column-name, ... ) }
[ SAMPLE p PERCENT ]

Usage

See TableStatistics.

Example

ANALYZE TABLE calendar_dimension COMPUTE STATISTICS FOR ALL COLUMNS;

ANALYZE TABLE calendar_dimension ESTIMATE STATISTICS FOR ALL COLUMNS;