Indexes with INCLUDE columns in DB2 can optimize ________.

  • Data retrieval performance
  • Data storage efficiency
  • Index creation
  • Query performance
Indexes with INCLUDE columns in DB2 can optimize query performance. By including additional non-key columns in the index, DB2 can cover more queries, reducing the need to access the base table and improving query performance. 
Add your answer
Loading...

Leave a comment

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