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 |
|
gemispence
Yak Posting Veteran
71 Posts |
 Posted - 2006-02-16 : 15:35:58
|
| Do you have to take the DB offline to create or run indexes in SQL Server 2000?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-16 : 15:37:50
|
| No, however things will slow down quite a bit on that table while the index is being created.Tara Kizeraka tduggan |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-02-17 : 08:22:49
|
| What I normally do is design the index I want to use and test it in a test/development database. When I'm satisified that the query(s) will run faster I'll take the script to create/modify that index and put it in a job and schedule it during off peak hours. I know that in our production environment I can create/modify an index for tables with about 500,000 rows or less with little or no impact. But anything over that, and users will feel the pain. I also take the table into account that is being indexed. For instance a Patient table that is hit by nearly every query, and I definately leave that table alone during production hours. |
|
|
|
|
|
|
Indexes