DROP_EXISTING

Jul 23, 2005

I´m recreating some clustered indexes on my database tables, and i'm
planning use DROP_EXISTING like this:


CREATE
CLUSTERED INDEX [idx-clusteredindex]
ON
[dbo].[TABLE_NAME]([COLOUMN_NANE])
WITH
DROP_EXISTING,
FILLFACTOR = 90
ON
[PRIMARY]


As I understand this will also cause all non-clustered index
on the table to be rebuilt/recalculated as well.
Is this infact the case of do I have to
do i have to do it explicitly afterwards like:


DBCC DBREINDEX ([dbo].[TABLE_NAME],[idx-nonclustered],90)

View 1 Replies


ADVERTISEMENT

Create INDEX WITH DROP_EXISTING

Jul 24, 2007

Hello,

Can I create an index ( which is not clustered) with DROP_EXISTING ON ?
Shall I still use on [PRIMARY]?

Create INDEX [name] ON [table name] ([column])
WITH DROP_EXISTING ON [PRIMARY]

Thank you,
Y
:rolleyes:

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved