Analyze Datasets (Data Management)

This ArcGIS 2.9 documentation has been archived and is no longer updated. Content and links may be outdated. See the latest documentation.

Summary

Updates database statistics of base tables, delta tables, and archive tables, along with the statistics on the indexes of those tables. This tool is used in enterprise geodatabases to help get optimal performance from the RDBMS query optimizer. Stale statistics can affect geodatabase performance.

Usage

  • The input workspace must be a database or enterprise geodatabase. The Analyze Datasets tool does not work with file or mobile geodatabases.

  • After data loading, deleting, updating, and compressing operations, it is important to update RDBMS statistics in the database.

  • The Include System Tables option is used to determine if the states and state lineage tables will be analyzed. These tables track traditional versions. When this option is not selected, the tables are not analyzed; when it's selected, the tables are analyzed.

  • When working with tables or datasets, this tool updates the statistics of base tables, delta tables, and archive tables, along with the statistics on the indexes of those tables.

  • The Add Value button of the Datasets to Analyze parameter is used only in ModelBuilder. In ModelBuilder, when the preceding tool has not been run or its derived data does not exist, the Datasets to Analyze parameter may not be populated with values. The Add Value button allows you to add expected values so you can continue to build your model.

  • This tool is not supported for use on SAP HANA.

Parameters

LabelExplanationData Type
Input Database Connection

The database that contains the data to be analyzed.

Workspace
Include System Tables

Specifies whether statistics will be gathered on the states and state lineages tables.

  • Unchecked—Statistics will not be gathered on the states and state lineages tables. This is the default.
  • Checked—Statistics will be gathered on the states and state lineages tables.
    Note:

    You must be the geodatabase administrator for this option to be active.

    This option only applies to geodatabases. If the input workspace is a database, this option will be inactive.

Boolean
Datasets to Analyze
(Optional)

The names of the datasets that will be analyzed. Only datasets that are owned by the connected user will be displayed.

String
Analyze Base Tables for Selected Dataset(s)
(Optional)

Specifies whether the selected dataset base tables will be analyzed.

Note:
This option only applies to geodatabases. If the input workspace is a database, this option will be inactive.

  • Checked—Statistics will be gathered for the base tables for the selected datasets. This is the default.
  • Unchecked—Statistics will not be gathered for the base tables for the selected datasets.
Boolean
Analyze Delta Tables for Selected Dataset(s)
(Optional)

Specifies whether the selected dataset delta tables will be analyzed.

Note:
This option only applies to geodatabases that contain traditional versions. If the input workspace is a database, this option will be inactive.

  • Checked—Statistics will be gathered for the delta tables for the selected datasets. This is the default.
  • Unchecked—Statistics will not be gathered for the delta tables for the selected datasets.
Boolean
Analyze Archive Tables for Selected Dataset(s)
(Optional)

Specifies whether the selected dataset archive tables will be analyzed.

Note:
This option only applies to geodatabases that contain archive-enabled datasets. If the input workspace is a database, this option will be inactive.

  • Checked—Statistics will be gathered for the archive tables for the selected datasets. This is the default.
  • Unchecked—Statistics will not be gathered for the archive tables for the selected datasets.
Boolean

Derived Output

LabelExplanationData Type
Updated Workspace

The updated workspace.

Workspace

Environments

Licensing information

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

Related topics