'SQL: Covering index in order to select all attributes?

say I have a database table of Id, Class, Name. I want to create a query where it selects all attributes if 'name' = 'John'. Would it make sense to use a covering index in this case like this?

Create index database_index ON database(name)

sql indexing

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'SQL: Covering index in order to select all attributes?

Sources

Related Questions