MySQL Unique, Index, and Fulltext indexing. All together of one is enough?
I wanted to have one specific column be unique and also optimized for searching and sorting. Meanwhile the same column should have fulltext search capability. Should I add all three indexing types (Unique, Index, and Fulltext) together on this column or not?
Please help and thanks.
Thanks @Fuujin for the quick comment.
What if I have the following indexing, no need for adding "Index" indexing anymore on neither of them, right?
ALTER TABLE `mytable` ADD UNIQUE (`column_1`, `column_2`);