natasha_sharma Posted March 16, 2016 Share Posted March 16, 2016 (edited) Once i create an index for mysql full text search, will the index gets updated automatically whenever there is new records/ deletion from the underlying table? The config of mysql is as below: Server: 127.0.0.1 via TCP/IP Server type: MariaDB Server version: 10.1.9-MariaDB - mariadb.org binary distribution Protocol version: 10 User: root@localhost Server charset: UTF-8 Unicode (utf8) Edited March 16, 2016 by natasha_sharma Quote Link to comment Share on other sites More sharing options...
QuickOldCar Posted March 16, 2016 Share Posted March 16, 2016 If have to create and remove tables and indexes should look into database normalization Create the index once and it keeps updating to the current data. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.