Is this also true when the query would involve a full table scan or clustered index scan anyway? Maybe I'm missing something crucial, but that doesn't seem to

Is this also true when the query would involve a full table scan or clustered index scan anyway? Maybe I'm missing something crucial, but that doesn't seem to make much sense for me from a data-access perspective.