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
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