Select to view content in your preferred language

arcpy attribute indexing vs ArcCatalog properties atrribut indexing

799
2
08-30-2012 07:23 AM
DDArnett
Deactivated User
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
Tags (2)
0 Kudos
2 Replies
MathewCoyle
Honored Contributor
Are you doing it directly on the table or through a tableview in python?
0 Kudos
DDArnett
Deactivated User
I am applying an index directly to the table (not using table view).
0 Kudos