#sql performance tuning db2 sql

3 SQL tuning ideas on Table Columns to apply

Three performance ideas of GROUP BY, IN or EXISTS and Duplicates in predicate given in this post. These ideas much useful to improve your SQL performance.

Group by

If you run a SQL query, it can consume less or more time. It all depends on how you have written the SQL. To improve performance, you need to understand the following ideas.

1. Always Use Group by

SQL Query DISTINCT vs…