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 |
|
scooter_r
Starting Member
4 Posts |
 Posted - 2006-12-21 : 13:43:45
|
| If I add a nonclustered index to an existing table, does it take the table offline while creating the index? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-21 : 13:45:00
|
| No.It occupies the CPU and disk system for a while, but it does not take the database offline.Peter LarssonHelsingborg, Sweden |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-21 : 14:22:36
|
| Well it does lock the table, can't remember the type of lock right now though. But it could cause blocking to occur during the index creation. SQL Server 2005 I believe handles it better now. Create indexes during your maintenance window to avoid any potential problems with the locking.Tara Kizer |
|
|
|
|
|
|
Does adding an index take table offline?