MariaDB Full Text Index - How to query old data as well I have added new full text index to mariadb

ALTER TABLE &lt;table name&gt; 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
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.