English

How To: Manage indexes on Cadastral Fabrics

Summary

When managing Cadastral Fabrics in a multi-user environment, users may experience some performance degradation with large datasets. Since the Cadastral Fabric is made up of a group of layers, one way to increase the speed and performance is to add indexing on certain Cadastral Fabric tables. Users expect to see performance gains when extracting and finishing Cadastral Fabric Jobs on SDE.

Procedure

The first index should be built on the Lines table.

  1. In ArcCatalog, right-click the Cadastral Fabric and select Properties, or double-click the Cadastral Fabric.
    [O-Image] [O]
  2. From the Properties dialog box, navigate to the Lines table by way of the Fabric Classes tab and select Properties.
    [O-Image]
  3. On the Lines Fabric Class Properties dialog box, select Add and create a new index by typing a new Name and selecting the frompointid field. Click OK.
    [O-Image]
  4. Repeat these steps for the topointid and centerpointid fields on the Lines table, as well as the same fields on the LinePoints table.
  5. Some Databases allow for manual recalculation of the spatial indexes. It is recommended that the spatial indexes are recalculated for the Lines and Linepoints table after adding these attribute indexes. Click the Recalculate button on the Fabric Class Properties dialog box.
    [O-Image]