DB2 Performance Ideas You Need to Implement in Project

The Author Craig Mullen presented great ideas, how performance can be improved with DB2 SQL.

Read DB2 questions, if you miss it.

  1. Always use query with where clause.
  2. Always create indexes on table.
  3. Explicit join is performance worth than Inner join.
  4. Always put exact columns that you want to retrieve in SELECT statement, not more than that.
  5. Use FETCH FIRST n ROWS ONLY. Take an example FETCH FIRST 1 ROWS ONLY, after returns 1 row, you will receive SQl CODE= +100.
  6. Use OPTIMIZE FOR n ROWS.
  7. For read only cursors always use FOR READ ONLY

Related items

Read more to get deep insights.

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.