Having too many indexes on a table in DB2 can lead to increased ________ overhead.

  • Maintenance
  • Memory
  • Processing
  • Storage
Too many indexes on a table in DB2 can lead to increased maintenance overhead. This is because each index needs to be updated whenever there are changes to the table data, which can impact performance. 
Add your answer
Loading...

Leave a comment

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