Performance

Full-Text Search Index

English

Overview

An index that treats words within text as searchable, enabling fast keyword search.

Details

While a normal B-tree index suits exact matches and range queries, this is designed to quickly find a word that appears anywhere within a body of text. It's commonly implemented using a mechanism called an inverted index.

More Database terms