What is a Covered Index?

SELECT *
FROM tablename
WHERE criteria

SELECT column1, column2
FROM tablename
WHERE criteria

CREATE TABLE MyTable
(
  ID INT IDENTITY PRIMARY KEY,
  Foo INT
)

CREATE NONCLUSTERED INDEX index1 ON MyTable(ID, Foo)

SELECT ID, Foo FROM MyTable -- All requested data are covered by index