Spatial grid indexes
Indexes improve application query performance by reducing the number of rows that need to be processed.
Db2® Spatial Extender provides a grid index that is optimized for two dimensional data. The index is created on the X and Y dimensions of a geometry.
The following
aspects of a grid index are helpful to understand:
- The generation of the index
- The use of spatial functions in a query
- How a query uses a spatial grid index