| Topic | Detail | Date |
| Clustering | Clustering determines how the rows are physically ordered in a tablespace. A high cluster ratio will have a positive impact on performance when using an index | Wednesday, January 18, 2006, 15:56 +05:30 |
| Index | Indexes are used to access the database faster. | Wednesday, January 18, 2006, 15:59 +05:30 |
| Isolation levels | DB2 Universal Database provides different levels of protection to isolate the data from each of the database applications while it is being accessed | Wednesday, January 18, 2006, 16:02 +05:30 |
| Uncommitted Read | The Uncommitted Read (UR) isolation level, also known as "dirty read," is the lowest level of isolation supported by DB2. It can be used to access uncommitted data changes of other applications. | Wednesday, January 18, 2006, 16:03 +05:30 |
| Cursor Stability | The Cursor Stability (CS) isolation level is the default isolation level and locks any row on which the cursor is positioned during a unit of work. | Wednesday, January 18, 2006, 16:03 +05:30 |
| Read Stability | Read Stability (RS) isolation level locks those rows that are part of a result set. If you have a table containing 100,000 rows and the query returns 10 rows, then only 10 rows are locked until the end of the unit of work. | Wednesday, January 18, 2006, 16:05 +05:30 |