I have three tables with 50m, 400m and 50m rows. I need to change the indexes completely. I am changing the indexes, not merely rebuilding them. What is the fastest way to do this?
1. SQL Script to DROP and CREATE indexes.
2. Unload table to text file, truncate data, change indexes, reload data?
Any other, better ways?
Thanks, tj