Analyze (Data Management)

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

Syntax

Analyze_management (in_dataset, components)
Parameter Explanation Datatype
Input Dataset (Required)

The table or feature class to be analyzed.

Layer | Table View | Dataset
Components to Analyze (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()

See Also

  • Compact (Data Management)