Computer Science for IGCSE & O level - Databases (Section 2 - No. 26)
What are the advantages of using indexes in a database?
Faster data retrieval for queries using indexed columns.
Reduced disk space usage.
Faster data insertion and update operations.
Improved overall database performance.
Explication
Indexes greatly improve data retrieval but can marginally slow down data modification.