What is FULL-TEXT index?

Question

What is FULL-TEXT index? Select all correct facts from the options below:

Answer 1

Full-text indexes are designed for searching words within large text columns like VARCHAR or TEXT.

Answer 2

A full-text index guarantees faster performance than a B-tree index for any query.

Answer 3

A FULL-TEXT index is a special index for efficient searching of words and phrases in large text columns.

Answer 4

Full-text indexes automatically support typo correction in all engines.

Answer 5

Full-text search often uses tokenization and can ignore stopwords depending on configuration.

Answer 6

Full-text indexes are identical across all SQL databases.

Answer 7

You can only create a full-text index on numeric columns.

Practice