Re: Create Indexes & extra columns!
From: David G. (david_nospam_at_nospam.com)
Date: 08/25/04
- Next message: Bernd Maierhofer \(dato\): "Re: How to detect the sql statement that causes full table scans"
- Previous message: Dean Penderghast: "Re: HELP!! Transaction Log is huge"
- In reply to: Jonas Larsen: "Create Indexes & extra columns!"
- Next in thread: Wayne Snyder: "Re: Create Indexes & extra columns!"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 01:39:59 -0400
Jonas Larsen wrote:
> Hi guys
>
> 2 questions.
>
> Is it recomenable to create
> 1. Indexes
> 2. extra columns
>
> on a table while the database is being used?
>
> I have not yet had the guts to do it while the database was in use
> however it would be somewhat easier if I could?
>
> Regards
> Jonas
Recommended is a loaded word. You can certainly perform both operations
while users are accessing the database. Adding a column should be quick
as long as you don't have to load data into the new column. Adding an
index is a more time consuming process if the table is large. If you
create a clustered index, you'll likely take the table offline until the
operation is complete and all non-clustered indexes are rebuilt.
If you are concerned about affecting the availability of the table in
question, schedule the operation to take place at night using the SQL
Server Agent.
-- David G.
- Next message: Bernd Maierhofer \(dato\): "Re: How to detect the sql statement that causes full table scans"
- Previous message: Dean Penderghast: "Re: HELP!! Transaction Log is huge"
- In reply to: Jonas Larsen: "Create Indexes & extra columns!"
- Next in thread: Wayne Snyder: "Re: Create Indexes & extra columns!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
