Skip to main content

Data performance tips

Available with the Linear Referencing license.

Implementing attribute and spatial indexes during data loading enhances the performance of any application. This is especially true for ArcGIS Linear Referencing because of the extensive data processing steps involved.

To get optimal performance in ArcGIS Linear Referencing, ensure that the appropriate indexes exist in your geodatabase. You can use the Add Attribute Index tool to create indexes.

The following table lists the recommended fields to be indexed for each LRS feature class and table:

Table name Multicolumn attribute index fields
LRS Network feature class Route ID, From Date, To Date, Route Name (if configured), Line ID (if configured), Line Name (if configured)
Calibration Point feature class Route ID, Network ID, From Date, To Date
Centerline feature class Centerline ID; for utility network: Route ID, From Measure, To Measure
Centerline Sequence table Route ID, Network ID, From Date, To Date, Centerline ID
Event feature class Event ID, Route ID, To Route ID (if configured), From Date, To Date
Intersection feature class Route ID, From Date, To Date
Table name Multicolumn attribute index fields
LRS Network feature class Route ID (the concatenated routeID in the network feature class), From Date, To Date, Route Name (if configured)
Calibration Point feature class Route ID, Network ID, From Date, To Date
Centerline feature class Centerline ID
Centerline Sequence table Route ID, Network ID, From Date, To Date, Centerline ID
Lookup table The key field (if configured in the lookup table)
Event feature class Event ID, Route ID, To Route ID (if configured), From Date, To Date
Intersection feature class Route ID, From Date, To Date

The geodatabase automatically creates and maintains spatial indexes for the centerline, calibration point, network, and event feature classes. In some circumstances, recalculating a spatial index can improve performance.