Full text searching uses TEXT indexes to search for terms and phrases in a database without having to scan table rows.
A TEXT index stores positional information for terms in the indexed column. Text configuration objects control the terms that are placed in a TEXT index when it is built or refreshed, and how a full text query is interpreted.
Using a TEXT index to find rows that contain a term or phrase is generally faster than scanning every row in the table.
