The Spatial page of the Index property sheet lets you define properties for creating or rebuilding an Oracle Spatial index. For detailed information about spatial indexing, see the Oracle Spatial User's Guide and Reference.
Hybrid Index
Uses a combination of fixed-size and variable-size tiles for spatially indexing a spatial column. Hybrid indexing is the preferred method with the newer object-relational model.
Fixed Index
Uses cover tiles of equal size for spatially indexing a spatial column. Fixed indexing is the preferred method with the older relational model. The Fixed Index option is not available when creating a new index or editing a hybrid index.
Initial tiling level: The tiling level at which to tile all objects in the spatial feature table (sdo_level parameter value).
Estimate button: Starts the Tiling wizard, which helps you to estimate the best value for Initial tiling level and Targeted number of tiles per object.
Target number of tiles per object (hybrid indexes only): Suggested number of tiles per object that should be used to approximate the shape (sdo_numtiles parameter value).
Maximum tiling level (hybrid indexes only): Maximum tiling level for any tile for any object (sdo_maxlevel parameter value). Must be greater than Initial tiling level.
Commit Interval
The number of geometries (rows) to process, during index creation, before committing the insertion of spatial index entries into the SDOINDEX table (sdo_commit_interval parameter value).
After all the rows have been processed: Commit after all rows have been processed (the default for Commit Interval).
Every [number] rows: Commit each time the specified number of rows have been processed.
The spatial column contains only Point data
If the spatial column contains only point data (no lines or polygons, for example), enable this option for optimal performance. Enabling this option is equivalent to specifying 'layer_gtype=POINT' in the index_params parameter of the CREATE INDEX statement or the rebuild_params parameter of the ALTER INDEX REBUILD statement.
Submit Job button
Lets you start a separate job to create or rebuild the index. Displays the Submit Job ialog box. You can immediately continue using the application, rather than having to wait until the create or rebuild operation is complete. On the other hand, if you click Apply or OK, the create or rebuild operation must complete before you can continue using the application.
See also: Main topics (outline)