Listing 2: Test Queries for the Employees Table in Northwind
-- Use the code below to generate test data showing
-- various execution plans against an object.
-- Index seek
SELECT  lastname
FROM dbo.employees
WHERE lastname = 'Fuller'
-- Index scan
SELECT  lastname
FROM dbo.employees
-- Clustered index scan
SELECT  *
FROM dbo.employees
-- Index seek and bookmark lookup
SELECT  *
FROM dbo.employees
WHERE lastname = 'Fuller'