DB2- Joins Performance Tuning

 List of performance tuning tips in SQL joins you need to follow.

  • Response time is determined mostly by the number of rows participating in the join
  • Provide accurate join predicates Provide accurate join predicates
  • Never use a JOIN without a predicate Never use a JOIN without a predicate
  • Join ON indexed columns Join ON indexed columns
  • Use Joins over subqueries
Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.