1

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 May 8 at 4:22
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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.