Re: Create Indexes & extra columns!
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/25/04
- Next message: Wayne Snyder: "Re: what are good IO througputs to expect for an OLTP system ?"
- Previous message: Wayne Snyder: "Re: implicit txn"
- In reply to: Jonas Larsen: "Create Indexes & extra columns!"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 07:54:26 -0400
I agree with David, if you choose to do this during the day, the structures
will still ( automatically) be unavailable until the process completes,
(which could take some time.)
most people would schedule this during off hours.... and backup prior...
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Jonas Larsen" <Jonas.Larsen@Alcan.com> wrote in message news:%23m%23Ai4liEHA.3288@TK2MSFTNGP10.phx.gbl... > 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 > >
- Next message: Wayne Snyder: "Re: what are good IO througputs to expect for an OLTP system ?"
- Previous message: Wayne Snyder: "Re: implicit txn"
- In reply to: Jonas Larsen: "Create Indexes & extra columns!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
