Index

Summary

The Index object contains information about an index on a table. There are two types of indexes: spatial and attribute. Spatial indexes exist on the shape field of a feature class.

Discussion

Index objects cannot be created directly. Index objects can accessed through the ListIndexes and Describe functions.

Properties

PropertyExplanationData Type
fields
(Read Only)

A Python List of field objects for the index.

Field
isAscending
(Read Only)

The isAscending state: True if the index is sorted in ascending order.

Boolean
isUnique
(Read Only)

The isUnique state: True if the index is unique.

Boolean
name
(Read Only)

The name of the index.

String

Code sample

Index example

Display index properties for specified table.

import arcpy

feature_class = "c:/data/well.shp"

# Create a list of indexes using the ListIndexes function
indexes = arcpy.ListIndexes(feature_class)

# Iterate through the list of indexes
for index in indexes:
    # Print index properties
    print("Name: {0}".format(index.name))
    print("\tType            : {0}".format(index.isAscending))
    print("\tScale           : {0}".format(index.isUnique))
    print("\tNumber of fields: {0}".format(len(index.fields)))

Related topics