Listing 3: Queries Requesting Sorted Data from the Base Table and the Ordered View
SET SHOWPLAN_TEXT ON
GO
SELECT * FROM T1
ORDER BY keycol DESC
SELECT * FROM VSortedT1TOP
ORDER BY keycol DESC
GO
SET SHOWPLAN_TEXT OFF