DB2 Five key areas to improve Performance

In DB2, performance tuning is the main role of Senior software developers. The real complex point is where you need to focus. I have given here key ares to improve performance.

Advantages of tuning

  1. Good performance reduces CPU time utilisation
  2. application running cost you can reduce.

Performance tuning tips in DB2

Right Access Path…

Here, how to find right access path.

  1. Access path determined by during bind time
  2. Access path at execution time

Statistics update…

  • DB2 checks catalog statics updated or not. So that it determines right access path

Index…

  • DB2 checks clustering index defined on any tables, which access so frequently

SQL query written in simple way…

  • SQL query should be as simple as possible
  • Avoid GROUP BY and ORDER BY
  • Avoid unused columns

Avoid Sorts in SQL query…

  • Use Indexes correctly, instead Sorting methods..like GROUP BY or ORDER BY etc

Also read

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.