The following two examples demonstrate Index Creation functionality.
The first example creates a High_Non_Group
(
HNG) index called
ShipIx on
the
ShipDate column of the
SalesOrderItems table.
CREATE HNG INDEX ShipIx
ON dbo.SalesOrderItems (ShipDate)
The second example creates a Low_Fast (
LF)
index called
SalesOrderRegionIX on the
Region column
of the
SalesOrder table.
CREATE LF INDEX SalesOrderRegionIx
ON dbo.SalesOrder (Region)