Explanation

An index helps the database quickly locate rows in a table without scanning the entire data.

It improves query performance by providing direct pointers to the data rows.