HOW TO

Create Oracle Spatial indexes when loading data with ArcCatalog

Last Published: April 25, 2020

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.

Article ID:000005925

Software:
  • ArcMap 8 x
  • ArcMap 9 x
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic