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.