ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Analyze

  • Summary
  • Usage
  • Syntax
  • Code sample
  • Environments
  • Licensing information

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.

Syntax

arcpy.management.Analyze(in_dataset, components)
ParameterExplanationData Type
in_dataset

The table or feature class to be analyzed.

Layer; Table View; Dataset
components
[components,...]

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.
String

Derived Output

NameExplanationData 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.

# Name: Analyze_Example.py
# 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/ninefour@gdb.sde/GDB.ctgPrimaryFeature"

# Execute Analyze
arcpy.Analyze_management(inDataset, "BUSINESS")

Environments

  • Current Workspace

Licensing information

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

Related topics

  • An overview of the Table toolset

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal