| Topic | Detail | Date |
| Package | A package contains access paths for a single DBRM. A package cannot be executed until it is bound to a plan | Wednesday, January 18, 2006, 15:48 +05:30 |
| Plan | A plan contains the access paths for all DBRMs bound to it, either explicitly or via a package. The plan is executable in conjunction with a program, a package is not. | Wednesday, January 18, 2006, 15:49 +05:30 |
| Normalization | Normalization eliminates duplicate data thus reducing the space overhead for maintaining them. | Wednesday, January 18, 2006, 15:50 +05:30 |
| De-normalization | De-normalization can be an advantage for performance issues, it can simplify the SQL because the data is easier to access. | Wednesday, January 18, 2006, 15:50 +05:30 |
| Sub-select | A subselect is a select query that is nested inside another query. It is needed when one SQL statement depends on the results of another. | Wednesday, January 18, 2006, 15:51 +05:30 |
| Join | A join is executed in one DB2 call and combines columns of 2 or more tables by matching data column values in the where clause. | Wednesday, January 18, 2006, 15:55 +05:30 |