>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>