SQL 2000: Index changes: What is fastest way?

  • 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

  • I would go for option 1. If you went for option 2 and loaded your data after creating the indexes then you'll probably find that loading the data is slower. Make sure you create your clustered index before the non-clustered ones.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply