|
 |
Business Intelligence
Indexing and statistics strategies for DB2 UDB for iSeries
|
Indexes and Optimization: A Summary
DB2 UDB for iSeries makes indexes a powerful tool. The following table summarizes some of the concepts discussed in this section.
| | Binary Radix | Indexes Encoded Vector Indexes |
| Basic data structure | A wide, flat tree | A Symbol Table and a vector |
| Interface for creating | Command, SQL, iSeries Navigator | SQL, iSeries Navigator |
| Can be created in parallel | Yes | Yes |
| Can be maintained in parallel | Yes | Yes |
| Used for statistics | Yes | Yes |
| Used for selection | Yes | Yes, via dynamic bitmaps or RRN list |
| Used for joining | Yes | No |
| Used for grouping | Yes | No |
| Used for ordering | Yes | No |
| Used to enforce unique Referential Integrity constraints | Yes | No |
[Back | Next]
|
|
|
|
|
