Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sean_B
Posting Yak Master
111 Posts |
 Posted - 2008-10-24 : 08:42:26
|
| Hi,I've a large table with 75 million rows, and it has an index on it.I want to make this index unique, is the only way to do this to drop and recreate the index.The table is heavily used and I'll need to schedule in a slot to re create the index.Sean |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-24 : 10:01:08
|
| You can alter index using ALTER INDEX. if you want table to be available for queries during REBUILD use WITH ONLINE ON optionhttp://technet.microsoft.com/en-us/library/ms188388(SQL.90).aspx |
 |
|
|
|
|
|
Alter index