We'll start with just the clustered index on the Users table, and you'll learn:

• SET STATISTICS IO ON shows the number of 8KB pages read by the query
• A WHERE without a supporting index results in a table scan
• ORDER BY without a supporting index results in high CPU work
• SQL Server caches data pages, not query results