3. FULLTEXT INDEX: It refers to an index used on text-based columns to perform fast and advanced searching. For example, in a product table, when you set the description column you can quickly search specific words or phrases inside large text using MATCH()...AGAINST(). This helps make text search faster and more efficient. Remember, only the column where you apply the full-text index will be searched, not the entire table.
Syntax:
CREATE FULLTEXT INDEX index_name ON table_name(column_name);