SQL — Analyze Database

 

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

Example usage in a BBj program:

SQLOPEN(sqlchan)"MyDatabase"
SQLPREP(sqlchan)"ANALYZE DATABASE"
SQLEXEC(sqlchan)

See SQL - Analyze Table for information on how to analyze a single table at a time.