- Drop the existing Non Clustered Indexes on the Table (if any)
- Drop the Clustered Index on the table
- Re-Create the Clustered Index on the table specify the Filegroup as PRIMARY.
CREATE CLUSTERED INDEX IndexName ON TableName(ColName) ON [PRIMARY] - Re-Create the Non Clustered Indexes (if any)
No comments:
Post a Comment