What is a common technique used in DB2 for query optimization?

  • Database normalization
  • Indexing
  • Partitioning
  • Query rewriting
Indexing contributes to query optimization in DB2 by organizing data in a structured way, allowing the database engine to efficiently locate and retrieve data, thereby improving query performance. It helps in reducing the number of rows scanned during query execution, resulting in faster response times. 
Add your answer
Loading...

Leave a comment

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