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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment