English

How To: Improve performance when geocoding a table against a large reference geocoding index

Summary

SQL Server: You can dramatically improve geocoding performance by creating a clustered covering index on the SX,XID columns of the geocoding index table.

Procedure

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

This command will return a long list. At the bottom, locate a string similar to this:

Code:
RD.Val.IdxTable1 = idb.DBO.GC_SS582

Use this table in your CREATE INDEX statement:

Code:
Create clustered index idxGC_Cov on dbo.GC_SS582(SX,XID)

You can also create an index with the Enterprise Manager.