As part of my app I allow people to adjust the full text indexing parameters (ie stop words, pass words, word length, delimiters and columns indexed). Is there a faster way to regenerate the indices once the parameters have been changed than to wizz through the Indexes (wince) and IndexColumns tables dropping and recreating them?

Roy Lambert

Roy,

<< As part of my app I allow people to adjust the full text indexing
parameters (ie stop words, pass words, word length, delimiters and columns
indexed). Is there a faster way to regenerate the indices once the
parameters have been changed than to wizz through the Indexes (wince) and
IndexColumns tables dropping and recreating them? >>

Not really.  There are easier ways (REPAIR TABLE), but they are not faster.
If you actually change some attribute of the text index, and not just the
underlying custom word generation or filtering, then using ALTER INDEX will
be faster than a DROP INDEX/CREATE INDEX cycle.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Not really. There are easier ways (REPAIR TABLE), but they are not faster.
>If you actually change some attribute of the text index, and not just the
>underlying custom word generation or filtering, then using ALTER INDEX will
>be faster than a DROP INDEX/CREATE INDEX cycle.

Fair enough. I think that most changes will be to the parameters for the word generator so I'll just leave the code I've written alone.

Roy Lambert