📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Quick Start

Guides

Connect
Manage Resources
Data Integration
Load Data
Unload Data
Multimodal Data Analytics
Performance Tuning
Security & Reliability
Management

Troubleshooting

Tutorials

Ingest & Stream Data
Migrate Data

Reference

SQL Reference
General Reference

Support Services

Spatial Index

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

Tip

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

TiDB Cloud Lake 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.

Geospatial Functions

Spatial Index

Spatial Index Management

Supported Predicates

Limitations

Related Topics

Was this page helpful?