>Hi All,
>
>Some time ago I believe I read a thread here that claimed a service pack included a new indexing routine in which VFP recreated all indices in a single pass thus greatly speeding up the reindex process. In my reindexing, I still see VFP making a pass at the table for each index. Am I doing something wrong or was that original post dated April 1 ?
>
>Thanks, Ken
SP3 changed the REINDEX command so that it makes a single pass through the table. IMO, the drawbacks of the REINDEX command outweigh the single pass.
BTW, where is Tolland? I was in Wallingford last week.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer