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.