SQLtest.online

Question

As MariaDB diverges further from MySQL (especially in versions 11+), how does the project approach "Compatibility"?

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

Full-text indexes are identical across all SQL databases.

Answer 6

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

Answer 7

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

Practice