What is the difference between a covering index and a regular index, and when should you use covering indexes?

Sample answer preview

A covering index is an index that contains all the columns needed to satisfy a query, allowing the database to retrieve results entirely from the index without accessing the main table.