An example of a non-clustered index


An example of a non-clustered index

In the below example, a non-clusted index is created on OrderQty and ProductID as follows
CREATE INDEX myIndex ON
SalesData (ProductID, OrderQty)

The following query will be retrieved faster compared to the clustered index.
SELECT Product ID, OrderQty
FROM SalesData
WHERE ProductID = 714

No comments:

Post a Comment