Data performance tips

Disponible avec la licence Location Referencing.

Database tuning and the implementation of attribute and spatial indexes during the data loading operation can enhance the performance of any application. This is especially true for data intensive applications such as ArcGIS Roads and Highways.

For optimal performance in Roads and Highways, ensure that your database has the appropriate indexes created. You can use the Add Attribute Index tool to create indexes.

Table nameMulticolumn attribute index fields

LRS Network feature class

  • RouteID (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

  • Key Field
  • (if the 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. In some circumstances, recalculating a spatial index can improve performance.