>
>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.
>
I see. So if I used Stonefield to do the reindexing, I was really creating indexes from scratch therefore the multiple passes. Makes sense.

>BTW, where is Tolland? I was in Wallingford last week.
Tolland is about 20 mi east of Hartford on I-84 heading towards Mass. Wallingford is south of Hartford on I-91. If you visit again give me a call.

Thanks,

Ken