Skip to main content

Full-Text & Spatial Indexes

Learn Full-Text & Spatial Indexes (Indexes, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A FULLTEXT index (InnoDB: inverted index of word to document) powers natural-language search with MATCH ... AGAINST . A SPATIAL index is an R-Tree over geometry columns (POINT, POLYGON) used for location queries.

More lessons in Indexes