DB2 Collects Table statistics in an automated way. This post tells you how Optimizer uses the Statistics for a better SQL query execution plan.
Category: DB2
In DB2, you can avoid unnecessary locking by following these Technics. These improve application performance.
Indexes improve the performance of the database tables. However, this post covers differences between clustered index and unique index.
In this post you can find how to Create and Delete DB2 user-defined functions.
Three top SQL queries you need to get Table metadata. Metadata means Table structure. That means to know indexes and columns of a Table in question.
Given examples of Date condition in the WHERE clause are useful for DATE comparison.
How to insert array of values in DB2 Tables explained with sample SQL query.
Real time best examples on DB2 special registers.
In DB2, buffer pools increases database performance. Explained the real benefits and how it works.
Top built-in functions added newly in DB2 version 11. Explained with examples.
Optimizer, Static SQL, Dynamic SQL like there are many specific keywords in DB2. Explained for you to read quickly.
Srinimf 
You must be logged in to post a comment.