1. Example. INDEX.sql

CREATE NONCLUSTERED INDEX IDX_Orders ON [ORDER](OrderDate);
GO
 
SELECT *
FROM [ORDER] ord
WITH (INDEX(IDX_Orders))
WHERE ord.OrderDate BETWEEN '20120828' AND '20120830';
GO
            
/** Output **/
Id          OrderDate               OrderNumber CustomerId  TotalAmount
----------- ----------------------- ----------- ----------- ---------------------------------------
45          2012-08-28 00:00:00.000 542422      81          1296.00
46          2012-08-29 00:00:00.000 542423      80          848.70
47          2012-08-30 00:00:00.000 542424      65          1887.60
 
DROP INDEX IDX_Orders ON [ORDER];
GO