ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Data performance tips

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 Esri Roads and Highways because of the extensive data processing steps involved.

To get optimal performance from mapping events in Roads and Highways, please ensure that your database has the appropriate indexes created.

Table nameMulticolumn attribute index fields

Route table

Route ID column or columns if a multifield Route ID

LRS Network feature class

  1. NetworkRouteID (the concatenated routeID in the network feature class)
  2. From Date
  3. To Date

Calibration Point feature class

  1. Route ID
  2. Network ID
  3. From Date
  4. To Date

Centerline feature class

  1. RoadwayIDGUID
  2. From Date
  3. To Date

Centerline Sequence table

  1. Route ID
  2. Network ID
  3. From Date
  4. To Date
  5. RoadwayIDGUID

Lookup table

  1. Key Field
  2. Display Field (if lookup table is configured with this field)

Event feature class

  1. Event ID
  2. Route ID
  3. From Date, To Date

Intersection feature class

  1. Route ID
  2. From Date
  3. To Date

Since the calibration point and centerline feature class 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 Modifying a spatial index.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2018 Esri. | Privacy | Legal