See the following query:

select a from test where c=10;

Suppose we have a composite index on columns(c,a). Will all the data in this case be retrieved using index without actually referring the base table?