query-optimization-2.sql

USE TestDB
GO

SET STATISTICS IO, TIME ON;

SELECT 
	* 
FROM
	Orders
WHERE
	OrderID IN (10260,10261,10262,10264,10265,10266,10267,10268);


SELECT 
	* 
FROM 
	Orders
WHERE
	OrderID = 10260
OR	OrderID = 10261
OR	OrderID = 10262
OR	OrderID = 10264
OR	OrderID = 10265
OR	OrderID = 10266
OR	OrderID = 10267
OR	OrderID = 10268;


SELECT 
	* 
FROM
	Orders
WHERE
	OrderID BETWEEN 10260 AND 10268;