CREATE NONCLUSTERED HASH INDEX IX_HashIndex
ON dbo.TableName (ColumnName);
CREATE NONCLUSTERED INDEX IX_MemoryOptimized
ON dbo.MemoryOptimizedTable (Column1, Column2);
CREATE CLUSTERED INDEX IX_Clustered
ON dbo.TableName (PrimaryKeyColumn);
CREATE NONCLUSTERED INDEX IX_NonClustered
ON dbo.TableName (Column1, Column2);
CREATE UNIQUE INDEX IX_Unique
ON dbo.TableName (UniqueColumn);
CREATE CLUSTERED COLUMNSTORE INDEX IX_Columnstore
ON dbo.TableName (Column1, Column2);
CREATE NONCLUSTERED INDEX IX_IncludedColumns
ON dbo.TableName (KeyColumn)
INCLUDE (Column1, Column2);
CREATE NONCLUSTERED INDEX IX_Computed
ON dbo.TableName (ComputedColumn);
CREATE NONCLUSTERED INDEX IX_Filtered
ON dbo.TableName (Column1)
WHERE Column2 = 'Value';
CREATE SPATIAL INDEX IX_Spatial
ON dbo.SpatialTable (SpatialColumn);
CREATE PRIMARY XML INDEX IX_Xml
ON dbo.XmlTable (XmlColumn);
CREATE FULLTEXT INDEX IX_FullText
ON dbo.TextTable (TextColumn)
KEY INDEX PK_TextTable;