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:clustered or not, you can use this.
Primary refers to the filegroup you would like to physically create the index on and it is an optional part of the create index statement.|||Thank you so much
Showing posts with label shall. Show all posts
Showing posts with label shall. Show all posts
Saturday, February 25, 2012
Create INDEX WITH DROP_EXISTING
Subscribe to:
Posts (Atom)