Skip to content

Instantly share code, notes, and snippets.

@kveratis

kveratis/RequildOrReorganizeIndex.sql

Created August 16, 2013 20:38
Show Gist options
  • Save kveratis/6253332 to your computer and use it in GitHub Desktop.
Save kveratis/6253332 to your computer and use it in GitHub Desktop.
Download ZIP
Code to either rebuild or reorganize an index
Raw
RequildOrReorganizeIndex.sql
--Rebuild Index
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON);
-- Reorganize Index
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee
REORGANIZE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment