Analyze (Data Management)
Summary
Updates database statistics of business tables, feature tables, and delta tables, along with the statistics of those tables' indexes.
Usage
This tool can only be used with data stored in an ArcSDE Geodatabase.
-
After data loading, deleting, updating, and compressing operations, it is important to update RDBMS statistics in Oracle, SQL Server, DB2, or Informix databases.
-
This tool updates the statistics of business tables, feature tables, raster tables, adds table, and deletes table, along with the statistics on those tables' indexes.
-
The Components to Analyze parameter's Add Value button is used only in ModelBuilder. In ModelBuilder, where the preceding tool has not been run, or its derived data does not exist, the Components to Analyze parameter may not be populated with values. The Add Value button allows you to add expected value(s) so you can complete the Analyze dialog box and continue to build your model.
Syntax
| Parameter | Explanation | Data Type |
in_dataset |
The table or feature class to be analyzed. | Layer; Table View ; Dataset |
components |
The component type to be analyzed.
| String |
Code Sample
This stand-alone Python script uses the Analyze tool to gather statistics for the indexes on the buisness table of the input dataset.
# Name: Analyze_Example.py
# Description: Gathers statistics for the indexes on the buisness table of the input dataset
# Import system modules
import arcpy
# Set local variables
inDataset = "Database Connections/ninefour@gdb.sde/GDB.ctgPrimaryFeature"
# Execute Analyze
arcpy.Analyze_management(inDataset,"BUSINESS")