Re: any impact if create index and then drop index
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 11/30/04
- Next message: Des FitzGerald: "Re: SQL Server Client Tools"
- Previous message: Tee: "How to know the sp_start_job job has failed?"
- In reply to: Mullin Yu: "any impact if create index and then drop index"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 10:02:23 +0100
On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: Des FitzGerald: "Re: SQL Server Client Tools"
- Previous message: Tee: "How to know the sp_start_job job has failed?"
- In reply to: Mullin Yu: "any impact if create index and then drop index"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
