DDW

arcpy attribute indexing vs ArcCatalog properties atrribut indexing

Discussion created by DDW on Aug 30, 2012
Latest reply on Aug 30, 2012 by DDW
I have a python script that creates a table from a text file then creates an index on one of the attribute fields. The purpose is to speed up searches on that field. In 10.1 I've noticed that the tables that are indexed through python are not as efficient as the table if indexed through ArcCatalog. The table indexed through the python script takes about 5 to 6 seconds to select a record while the same table if indexed through ArcCatalog\properties is instantaneous.

This is the line that is used in the script to index....
arcpy.AddIndex_management(geoTable, "ASSESSOR_N", "TaxLots", "NON_UNIQUE", "ASCENDING")
(The table is in a geodatabase).

Thanks

Outcomes