Rebuilt index not working.

Post Reply
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Rebuilt index not working.

Post by barry.marcus »

I just recreated an index using keepnoise = 1. As far as I can tell, that is the ONLY change that I made. (Famous last words, I know!) Now my application takes an extremely long time to return results using that index. The other indexes seem to work fine still? Any idea what I might have done. I don't even know where to look.

This may be a naive question, but is there some "switch" that enables an index sitting out on my server that somehow may have inadvertantly gotten switched "off"?

Here is the script I used to rebuild the index:

DROP INDEX PATN_ABST_PAx_MI;
set delexp=0;
set addexp = '\alnum{1,99}';
set keepnoise=1;
create METAMORPH INVERTED index PATN_ABST_PAx_MI on PATN(ABST_PAx\PATN_TTL,PATN_ISD);

Thanks
User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Rebuilt index not working.

Post by Kai »

Keeping noise words in the index can increase its size, and thus increase search time because less of the non-noise portions can be cached (and seek time increases). It should not be a significant increase in most circumstances however.

To test if an index is being used, you could run the query from the command line with tsql -V and see if it opens the index.
Post Reply