Reduced Disk I/O: Indexes reduce the need for the database to read large portions?

of data from disk.

In summary, indexes drastically speed up SELECT queries at the cost of increased overhead

during INSERT, UPDATE, and DELETE operations.