Covering index is right. Select * has a few valid use cases. If you're selecting from a cte or subquery then writing the same column list twice is redundant a

Covering index is right. Select * has a few valid use cases. If you're selecting from a cte or subquery then writing the same column list twice is redundant and increases complexity/risk of mistakes. * is also harmless for count and exists.