English

How To: Maximize Dynamic Segmentation performance

Summary

This article provides some tips to improve performance when drawing and querying route events.

Procedure

Index the event key item in the event table and the route key item in the route feature class.

  1. Create an attribute index for shapefile and dBase tables
    1. Click the shapefile or dBASE table to which you want to add an attribute index.
    2. Click the File menu and click Properties.
    3. Click the Index tab.
    4. Check an attribute to index its values.
    5. Click OK.
  2. Create an attribute index for geodatabase data
    1. In the Catalog tree, right-click the table or feature class for which you want to create an index.
    2. Click Properties.
    3. Click the Indexes tab.
    4. Click Add.
    5. Type the name for the new index.
    6. Check the Unique check box if your field values are unique. Check the Ascending check box to create an ascending index. Data in an ascending index is returned in ascending order.
    7. Click the field or fields for which you want to build this index.
    8. Click the arrow button to move the fields to the Fields selected list.
    9. Use the up and down arrows to change the order of the fields in the index.
    10. Click OK.
    11. Click Apply to build the index or click OK to build the index and close the Properties dialog box.
Use spatial indexes on non-geodatabase feature classes. Geodatabase feature classes will have spatial indexes created automatically when they are created.
  1. Create a spatial index for a shapefile
    1. Click the shapefile for which you want to create a spatial index.
    2. Click the File menu and click Properties.
    3. Click the Index tab.
    4. Click Add.
    5. Click OK.
Route event tables are often very large and you may wish to only display a subset of them. If the event table is stored in a RDBMS software, create a view on the route event table that contains only those events you want to be displayed.