Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (3.5k points)

As the title states, what is a fulltext index and when should I use it?

1 Answer

0 votes
by (8.7k points)

The fulltext index is considered to be a special type of indexes that provide index access for complete text query against a column or for binary column data. This is achieved as it breaks the column and converts them into tokens and after that, these tokens contribute to the index data.

Fulltext index really works better for regular text as it simply breaks the word and makes the indexes out of the word in spite of taking the whole text as result it comes out to be faster for searches when looking for the words.

Interested in SQL? Check out this SQL certification by Intellipaat.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94.1k users

Browse Categories