statsestimate

Syntax

statsestimate [[owner_name.]table_name] {n rows | p percent}

Description

Estimates statistics for specified table (or all tables if no table is specified).

If you estimate statistics with an empty table list, statistics on system tables are updated also, if you have privileges to update the system tables.

Examples

Command> statsestimate SCOTT.T1 1000 ROWS;