SQL — Analyze Table

 

The ANALYZE TABLE command performs a table performance analysis operation on the specified table on the currently connected database. The number of records in the table affects the amount of time this operation requires.

Example usage in a BBj program:

SQLOPEN(sqlchan)"MyDatabase"
SQLPREP(sqlchan)"ANALYZE TABLE my_table"
SQLEXEC(sqlchan)

See also SQL - Analyze Database