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
|All times are GMT +1. The time now is 01:53 AM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.