>To add to what Craig said -- you still get the multiple reindexing messages, but the information needed to create all the indexes is gathered on the first pass thru the table. If you will notice that each index creation after the first one is much faster. At least it is this way on my machine.
On the test I did, I used a table with nearly 2 million records, and 7 index tags. The table is 1.5 GIGs in size. The reindexing operation took nearly
1.5 hours, and it did make multiple passes through the table creating the keys. the indexing then was less than 2 seconds. As each succeeding key was added, the operation took measurably longer (a few seconds) to complete. The temp files grew quite large during the key creation part of the operation, were emptied, then grew again on each pass.
As a result, I am as lost as ever before <eg>
MSCE, MCSP, Microsoft Channel Partner
Relax, Boss. We will meet the deadline! What? You want to add MORE? What do you mean, Over Budget?
Opinions and comments are the sole responsibility of the sender, and accuracy, correctness, or pertinence is considered coincidental.