TADSQLiteValidate.Analyze Method

Starts the statistics gathering task.

Group

Links

TADSQLiteValidate Class, TADSQLiteValidate Members, uADPhysSQLite Namespace, public, See Also

Parameters	Description
const ATable: String = ''	A database table name.
const AIndex: String = ''	A database index name.

Description

Use the Analyze method to start the database statistics gathering task.

To perform a statistics gathering task an application must specify the connection parameters and Database. This is a programmatic method to invoke the ANALYZE command. Depending on the specified arguments the method modes are:

AIndex only - analyzes the specified index.
ATable only - analyzes all indexes for the specified table.
None specified - analyzes all indexes for all tables in the database.

Syntax

procedure Analyze(const ATable: String = ''; const AIndex: String = '');