DB2: Guidelines to Write SQL Join Query

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

  1. Response time is determined mostly by the number of rows participating in the join
  2. Provide accurate join predicates Provide accurate join predicates
  3. Never use a JOIN without a predicate Never use a JOIN without a predicate
  4. Join ON indexed columns Join ON indexed columns
  5. Use Joins over subqueries

Related Posts

Author: Srini

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