Spatial Index

Spatial indexes in Databend accelerate spatial predicate filtering on GEOMETRY columns. They are designed for Fuse tables and help the optimizer prune blocks before evaluating exact spatial functions.

Key Feature: Automatic Index Generation

Spatial indexes are maintained automatically for data written after the index is created. Use REFRESH SPATIAL INDEX when you create an index on a table that already contains data and need to backfill existing rows.

Spatial Index Management

Command	Description
CREATE SPATIAL INDEX	Creates a new spatial index on one or more GEOMETRY columns
REFRESH SPATIAL INDEX	Backfills spatial index data for rows that existed before index creation
DROP SPATIAL INDEX	Removes a spatial index from a table

Supported Predicates

Databend can use spatial indexes to accelerate queries built with these spatial predicates:

• ST_CONTAINS
• ST_INTERSECTS
• ST_WITHIN
• ST_DWITHIN

Limitations

• Spatial indexes are supported on Fuse tables.
• Indexed columns must be of type GEOMETRY.
• GEOGRAPHY columns are not supported.

Related Topics

• Geospatial Functions