Indexes stopped working
I had some full text indexes that stopped working. I wasn't getting the expected results from my search. I created the indexes when i created the database. But the data is always being truncated then reinserted from another server via a script. When i do this upload do i need to do anything with the indexes. I assumed when i uploaded the database and as the data was inserted it would recreate the indexes. Or does it not do this? If it does then how can i find out what happened to my index?
I found that this command had resolved the problem and fixed the index
ALTER TABLE `DB_NAME`.`PRODUCT` DROP INDEX `PRODUCT_SIMPLE_INDEX` ,
ADD FULLTEXT `PRODUCT_SIMPLE_INDEX` (