This document is archived and information here might be outdated. Recommended version. |
Analyze the table to generate DBMS statistics.
[Visual Basic .NET]
Public Sub AnalyzeTable ( _
ByVal TableName As String, _
ByVal tableComponents As Integer _
)
[C#]
public void AnalyzeTable (
string TableName,
int tableComponents
);
[C++]
HRESULT AnalyzeTable(
BSTR TableName,
long tableComponents
);
[C++] Parameters TableName [in]
TableName is a parameter of type BSTR tableComponents [in]
tableComponents is a parameter of type long
The AnalyzeTable and AnalyzeIndex methods can be used to acquire DBMS statistics on tables and table indexes. Having up-to-date statistics on a table is key to efficient query performance on the table and a key requirement for efficient queries against versioned tables. Note that datasets that are based on tables support the IDatasetAnalyze method; to analyze all of the tables in a feature dataset, use the IDatasetAnalyze::Analyze method on the feature dataset.
The TableComponents arguement takes values from the enumeration esriTableComponents. These values include esriAddsTable, esriBusinessTable, esriDeletesTable, esriFeatureTable, and esriRasterTable. The values can also be combined together. For example, to analyze the business, adds, and deletes table, you would specify (esriBusinessTable + esriAddsTable + esriDeletesTable)