How does indexing impact the performance of read and write operations in a database?

  • It significantly slows down both read and write operations.
  • It has no impact on read operations but speeds up write operations.
  • It significantly speeds up read operations but has no impact on write operations.
  • It significantly speeds up both read and write operations.
Indexing in a database can significantly speed up read operations because it allows the database system to quickly locate specific records. However, it can slightly slow down write operations because the database needs to update the index when new data is inserted or existing data is updated.
Add your answer
Loading...

Leave a comment

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