Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Indexes stopped working
03-07-2013, 04:48 PM #1
- Join Date
- Aug 2006
- Thanked 110 Times in 109 Posts
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` ( `FullProductDescription` , `Description` )You can not say you know how to do something, until you can teach it to someone else.