English

How To: Create Oracle Spatial indexes when loading data with ArcCatalog

Summary

If geodatabase data is stored as Oracle Spatial, you have a choice of various index schemes, such as no spatial index, an R-tree index, a Fixed Quadtree index, or a Hybrid Quadtree index. Fixed indexing uses a linear quadtree index based on a tile size. Hybrid indexing uses both the fixed tile sizing and a variable sized tiling.

Procedure

Whether a fixed or hybrid index is used, a tiling level is used to define the location of a geometry. Choosing the best tiling level for fixed indexing or the best number of tiles per geometry for hybrid indexing can impact performance.

The parameters required for these indexing schemes are as follows:

  • DBTune:
    Grid level 1: 0
    Grid level 2: 0
    Grid level 3: 0
  • No index:
    Grid level 1: -1
    Grid level 2: ignored
    Grid level 3: ignored
  • R-tree index:
    Grid level 1: -2
    Grid level 2: ignored
    Grid level 3: ignored
  • Fixed quadtree index:
    Grid level 1: -3
    Grid level 2: <fixed tile size>
    Grid level 3: ignored
  • Hybrid quadtree index:
    Grid level 1: -4
    Grid level 2: <fixed tile size>
    Grid level 3: <number of tiles per geometry>
    Note:
    For more information on these indexing schemes, refer to the ArcSDE Configuration and Tuning Guide and the Oracle Spatial Documentation.