Multiple choice technology databases

What is an index?

  1. An index is the same as alias

  2. An index is a database table attribute, which speeds-up data search within a table

  3. An index is a special way to join 2 or more tables

  4. None of above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An index is a database structure that creates a lookup table on one or more columns, dramatically speeding up data retrieval. Similar to a book index, it allows the database to find rows without scanning the entire table. Indexes trade off storage space and slower inserts/updates for faster query performance.

Keep practicing — related questions