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 enterprise 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 tool's dialog box and continue to build your model.

Parameters

Dialog

Label	Explanation	Data Type
Input Dataset	The table or feature class to be analyzed.	Layer; Table View; Dataset
Components to Analyze	Specifies the component type that will be analyzed. Business table—Business rules statistics will be updated. Feature table—Feature statistics will be updated. Raster table—Statistics on raster tables will be updated. Adds table—Statistics on added datasets will be updated. Deletes table—Statistics on deleted datasets will be updated.	String

Derived Output

Label	Explanation	Data Type
Output Dataset	The geodatabase input dataset with updated statistics.	Layer; Table View; Dataset

Python

arcpy.management.Analyze(in_dataset, components)

Name	Explanation	Data Type
in_dataset	The table or feature class to be analyzed.	Layer; Table View; Dataset
components [components,...]	Specifies the component type that will be analyzed. BUSINESS—Business rules statistics will be updated. FEATURE—Feature statistics will be updated. RASTER—Statistics on raster tables will be updated. ADDS—Statistics on added datasets will be updated. DELETES—Statistics on deleted datasets will be updated.	String

Derived Output

Name	Explanation	Data Type
out_dataset	The geodatabase input dataset with updated statistics.	Layer; Table View; Dataset

Code sample

Analyze example (stand-alone script)

This stand-alone Python script uses the Analyze tool to gather statistics for the indexes on the business table of the input dataset.

# Description: Gathers statistics for the indexes on the business table of the input dataset

# Import system modules
import arcpy

# Set local variables
inDataset = "c:/Connections/[e-mail]/GDB.ctgPrimaryFeature"

# Run Analyze
arcpy.management.Analyze(inDataset, "BUSINESS")

Environments

Current Workspace

Licensing information

• Basic: No
• Standard: Yes
• Advanced: Yes