php - MySQL: Fulltext indexing previous records? -
I added a complete index index to three of my columns, since I had a bunch of records ... its meaning FULLTEXT will not index them and will only index indexes be added after the FULLTEXT index is added? If so, then still have to rewrite entire database?
When you index an optional table, then the old records are immediately indexed (and new records
Please note that, sometimes (like when you change the option ft_min_word_len, ft_max_word_len, or ft_stopword_file options) you can recreate a FULLTEXT index See, details.
Comments
Post a Comment