DB2 Optimization

SQL Query Optimization: Tips & Tricks

SQL Query optimization is a process of writing optimized SQL queries to improve database performance. It is one of the…

5 years ago

FETCH FIRST n ROW ONLY and OPTIMIZE FOR n ROWS

The FETCH FIRST n ROW ONLY clause is used to limit the result set of a query to a specified…

7 years ago

DB2 NULL Indicator use in SQL Queries

A DB2 null Indicator/value represents missing or unknown information at the column level. When a column is set as null,…

7 years ago

DB2 locking and concurrency – Tips & Trick

DB2 locking and concurrency is a critical part of DB2 as well as batch performance.  Batch update jobs processing large…

7 years ago