In database design, how does indexing improve query performance?

  • It has no impact on query performance.
  • It improves query performance.
  • It only improves data storage.
  • It slows down query performance.
Indexing in database design helps in faster data retrieval by creating a data structure that maps key values to their locations in the database. This significantly speeds up query performance, especially for large datasets.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *