LISTING 3: First Query on the Customers Table

CREATE INDEX i_country on customers(country)
GO
SELECT customerid from customers
   WHERE gender = 'M' and country = 'Germany'