topic Re: arcpy attribute indexing vs ArcCatalog properties atrribut indexing in Python Questions https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490724#M38405 <HTML><HEAD></HEAD><BODY><SPAN>I am applying an index directly to the table (not using table view).</SPAN></BODY></HTML> Thu, 30 Aug 2012 18:34:15 GMT DDArnett 2012-08-30T18:34:15Z arcpy attribute indexing vs ArcCatalog properties atrribut indexing https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490722#M38403 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN><BR /><BR /><SPAN>This is the line that is used in the script to index.... </SPAN><BR /><SPAN>arcpy.AddIndex_management(geoTable, "ASSESSOR_N", "TaxLots", "NON_UNIQUE", "ASCENDING")</SPAN><BR /><SPAN>(The table is in a geodatabase).</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Thu, 30 Aug 2012 14:23:13 GMT https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490722#M38403 DDArnett 2012-08-30T14:23:13Z Re: arcpy attribute indexing vs ArcCatalog properties atrribut indexing https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490723#M38404 <HTML><HEAD></HEAD><BODY><SPAN>Are you doing it directly on the table or through a tableview in python?</SPAN></BODY></HTML> Thu, 30 Aug 2012 18:19:27 GMT https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490723#M38404 MathewCoyle 2012-08-30T18:19:27Z Re: arcpy attribute indexing vs ArcCatalog properties atrribut indexing https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490724#M38405 <HTML><HEAD></HEAD><BODY><SPAN>I am applying an index directly to the table (not using table view).</SPAN></BODY></HTML> Thu, 30 Aug 2012 18:34:15 GMT https://community.esri.com/t5/python-questions/arcpy-attribute-indexing-vs-arccatalog-properties/m-p/490724#M38405 DDArnett 2012-08-30T18:34:15Z