Multiple choice technology testing

What best describes the relationship between indexes and SQL performance?

  1. Indexes are only used in special cases

  2. Indexes are used to make table storage more efficient

  3. Indexes rarely make a difference in SQL performance

  4. Indexes exist solely to improve query speed
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Indexes are database structures created to optimize query execution speed. While they consume extra storage space and can slow down data modification operations, their primary purpose is to enhance read performance.

Keep practicing — related questions