Data performance tips

Available with Location Referencing license.

Proper tuning of the database and the implementation of attribute and spatial indexes during the data loading operation will enhance the performance of any application. This is especially true for ArcGIS Pipeline Referencing because of the extensive data processing steps involved.

To get optimal performance from mapping events in Pipeline Referencing, make sure that your database has the appropriate indexes created. You can use the Add Attribute Index geoprocessing tool to create indexes.

Table name	Multicolumn attribute index fields
LRS Network feature class	RouteID 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: RouteID FromMeasure ToMeasure
Centerline Sequence table	Route ID Network ID From Date To Date Centerline ID
Lookup table	Key Field (if lookup table is configured with this field)
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

Since the centerline, calibration point, network, and event feature classes are stored in a geodatabase, spatial indexes are automatically created and maintained for you. In some circumstances, recalculating a spatial index may improve performance, as described in Modify a spatial index.