Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is an index in a database primarily used for?

  1. A Speeding up reads by allowing the engine to locate rows without scanning the table
  2. B Reducing storage size
  3. C Enforcing data types
  4. D Compressing data
Answer

Speeding up reads by allowing the engine to locate rows without scanning the table

Indexes slow down writes, since every insert and update must maintain them, so they are a trade-off rather than a free improvement.

All Data MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as