MariaDB Full Text Index - How to query old data as well

Question

I have added new full text index to mariadb

ALTER TABLE <table name> ADD FULLTEXT INDEX records

I can query against this index only newly added and updated records but for older records (which is added before this index) I cannot query

Is there any workaround that I can also fetch older records

Give an example. Adding the index should index the entire table. Also provide version number and SHOW CREATE TABLE. — Rick James, Commented May 8, 2020 at 4:22

nbk · Accepted Answer · 2020-05-05 15:48:41Z

1

normally it would be build, when you added the index

But you can OTIMIZE TABLE yourtablename

The fulltext index is only fully re-organized when an OPTIMIZE TABLE statement is run.

answered May 5, 2020 at 15:48

nbk

8,6686 gold badges14 silver badges27 bronze badges

Add a comment |

1 Answer 1