Listing 3: Queries to Compare the Negative Effects of ORDER BY in a View
SELECT P.ProductName, Sales.Total
FROM dbo.AllProductSales AS Sales
	JOIN dbo.Products AS P ON Sales.ProductID = P.ProductID
ORDER BY P.ProductName

SELECT P.ProductName, Sales.Total
FROM dbo.AllProductSalesOrdered AS Sales
	JOIN dbo.Products AS P ON Sales.ProductID = P.ProductID
ORDER BY P.ProductName