Heads up on "reindex"....

[Kenneth Brody]

Quoting Nancy Palmquist (Wed, 02 May 2007 15:13:14 -0400):
[...]
> -ra is a nice flag but it only rebuild existing indexes the same way
> they are currently sorted.
>
> I think a better method is to create a script that records the indexes
> and sorts when they are pristine and then use it to rebuild.
>
> I have had many times when a customer has altered the sort on an index
> or accidentaly deleted an index and without such a script you are trying
> to figure out what index(s) are broken or missing.
[...]

You could use the IXSORT() function to grab the information from a
current set of indexes to be saved for later, or to generate a script
to (re)build the indexes.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com