DROP_EXISTING
Jul 23, 2005I´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)