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