-- Create an index on a table
CREATE INDEX index_name
ON table_name (column1, column2, ...);
-- View all indexes on a table
EXEC sp_helpindex 'table_name';
-- Remove an index from a table
DROP INDEX table_name.index_name;
-- Rebuild an index
ALTER INDEX index_name ON table_name REBUILD;
-- Disable an index
ALTER INDEX index_name ON table_name DISABLE;
-- Reorganize an index
ALTER INDEX index_name ON table_name REORGANIZE;
-- View the fragmentation level of an index
SELECT index_name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(N'database_name'), OBJECT_ID(N'table_name'), NULL, NULL, 'DETAILED');