4. SPATIAL INDEX: It refers to an index applied to spatial (geometry) data types like POINT, LINESTRING, POLYGON, etc. For example, in the places table, when you set a spatial index on the location column, it helps efficiently store geographical coordinates and allows faster querying of those coordinates. This index is mainly used in mapping or GIS-based applications.
Syntax:
CREATE SPATIAL INDEX index_name ON table_name(column_name);