If it's an option, buy more RAM and more disks..
Is it a 17gb table or 17gb of data spread across several tables? If
it's across several tables, you won't have as much trouble rebuilding
the indexes.
Another option is to build another machine with a bunch of ram and a
RAID1 or RAID10 (SATA or SCS
I doubt there is much to do. Your hardware is the bottleneck I would
think. You will completely kill the server regenerating the indexes
afterwards as well, so if the idea is to get is up and running fast, it
may not be so fast once you get it up.
-Original Message-
From: Mikel - [mailto:[