Is This Content Helpful?
We're glad to know this article was helpful.
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:
sdelocator -o describe -n citystreets -i 9000 -u geocode -p find_address -D idb
RD.Val.IdxTable1 = idb.DBO.GC_SS582
Create clustered index idxGC_Cov on dbo.GC_SS582(SX,XID)