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

Property	Explanation	Data 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

fc = "C:/Data/well.shp"

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

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