HOW TO

Improve performance when geocoding a table against a large reference geocoding index

Last Published: April 25, 2020

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.

Article ID:000003254

Software:
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options