FireDAC.Phys.SQLite.TFDSQLiteValidate.Analyze
Delphi
procedure Analyze(const ATable: String = ''; const AIndex: String = '');
C++
void __fastcall Analyze(const System::UnicodeString ATable = System::UnicodeString(), const System::UnicodeString AIndex = System::UnicodeString());
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | FireDAC.Phys.SQLite.pas FireDAC.Phys.SQLite.hpp |
FireDAC.Phys.SQLite | TFDSQLiteValidate |
Description
Starts the statistics gathering task.
Use the Analyze method to start the database statistics gathering task.
| Parameters | Description |
|---|---|
|
const ATable: String = ' ' |
A database table name. |
|
const AIndex: String = ' ' |
A database index name. |
To perform a statistics gathering task an application must specify the connection parameters and the 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.