HOW TO
SQL Server: You can dramatically improve geocoding performance by creating a clustered covering index on the SX,XID columns of the geocoding index table.
Execute the Transact-Sql CREATE INDEX command against your geocoding index table. Identify your geocoding index table by running the sdelocator command with the -o describe option. For example:
Code:
sdelocator -o describe -n citystreets -i 9000 -u geocode -p find_address -D idb
Code:
RD.Val.IdxTable1 = idb.DBO.GC_SS582
Code:
Create clustered index idxGC_Cov on dbo.GC_SS582(SX,XID)
Get help from ArcGIS experts
Download the Esri Support App