Single-column index is one of the types of database indexing that help you to improve performance of queries.
Example
In the example below, we are trying to find a record by name.
Without indexing, it would look like this
Single-column index table will look like this
