Tuning spatial grid indexes with the Index Advisor
Db2® Spatial Extender provides the Index Advisor utility to help you optimize access to spatial data.
Use the Index Advisor to:
- Determine appropriate grid sizes for your spatial grid indexes.
The Index Advisor analyzes the geometries in a spatial column and recommends optimal grid sizes for your spatial grid index.
- Analyze an existing grid index.
The Index Advisor can collect and display statistics from which you can determine how well the current grid cell sizes facilitate retrieval of the spatial data.