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.
Article ID:000005925
Software:
- ArcMap 8 x
- ArcMap 9 x
- Legacy Products
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App