How can indexing contribute to performance tuning in DB2?

  • By normalizing the database
  • By partitioning tables
  • By reducing the number of rows scanned
  • By rewriting SQL queries
Indexing contributes to performance tuning in DB2 by reducing the number of rows scanned during query execution. This optimization technique allows the database engine to quickly locate and retrieve data based on the indexed columns, resulting in improved query performance and overall system efficiency. 
Add your answer
Loading...

Leave a comment

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