Even when there is no definite starting or stopping point for an index
scan, an index can speed up the execution of a query if the index covers the
query. An index covers the query if all the columns
specified in the query are part of the index. These are the columns that are
all columns referenced in the query, not just columns in a WHERE clause. If
so,