Analyze (Data Management) (ArcInfo and ArcEditor only)
Release 9.2 Last modified November 29, 2010	Print all topics in : "Tools"

Updates relational database management system (RDBMS) statistics of business tables, feature tables, and delta tables along with the statistics of those tables' indexes

Usage tips

• After data loading, deleting, updating, and compressing operations, it is important to update RDBMS statistics in Oracle, SQL Server, DB2, or Informix databases.

• The Analyze function updates the statistics of business tables, feature tables, raster tables, added tables, and deleted tables, 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 and continue to build your model.

• The environment settings do not have an effect on this tool.

Command line syntax
An overview of the Command Line window
Analyze_management <in_dataset> <BUSINESS | FEATURE | RASTER | ADDS | DELETES>

Parameter	Explanation	Data Type
<in_dataset>	The table or feature class to be analyzed.	Layer | Table View | Dataset
<BUSINESS | FEATURE | RASTER | ADDS | DELETES>	The component type to be analyzed. BUSINESS — Updates business rules statistics. FEATURE — Updates feature statistics. RASTER — Updates statistics on raster tables. ADDS — Updates statistics on added datasets. DELETES — Updates statistics on deleted datasets. The Add Value button, which is used only in ModelBuilder, allows you to add expected value(s) so you can complete the dialog and continue to build your model.	String

Data types for geoprocessing tool parameters

Command line example

workspace "Database Connections\Oracle_SDE.sde"
Analyze oraspatial.accident BUSINESS

Scripting syntax
About getting started with writing geoprocessing scripts
Analyze_management (in_dataset, components)

Parameter	Explanation	Data Type
in_dataset (Required)	The table or feature class to be analyzed.	Layer | Table View | Dataset
components (Required)	The component type to be analyzed. BUSINESS — Updates business rules statistics. FEATURE — Updates feature statistics. RASTER — Updates statistics on raster tables. ADDS — Updates statistics on added datasets. DELETES — Updates statistics on deleted datasets. The Add Value button, which is used only in ModelBuilder, allows you to add expected value(s) so you can complete the dialog and continue to build your model.	String

Data types for geoprocessing tool parameters

Script example

# Purpose: Analyze a database table after data loading 

# Create the Geoprocessor object
import arcgisscripting
gp = arcgisscripting.create()

try:
    # Set the workspace (to avoid having to type in the full path to the data every time)
    gp.Workspace =  "Database Connections/Oracle_SDE.sde"

    # Process: Update business rules statistics of a table
    gp.Analyze("oraspatial.accident", "BUSINESS") 

except
    # If an error occurred while running a tool print the messages
    print gp.GetMessages()

Please visit the Feedback page to comment or give suggestions on ArcGIS Desktop Help.
Copyright © Environmental Systems Research Institute, Inc.