Computer Science for IGCSE & O level - Databases (Section 4 - No. 46)

What is the purpose of an index in a database?
To enforce data validation rules.
To speed up data retrieval.
To store the actual data.
To define relationships between tables.

Explanation

An index improves query performance by providing a quick lookup path for data based on specific columns.

Comments (0)

Advertisement