Chapter 12. Indexes, Sequences, and Views

Storing data in tables and managing its manipulation with stored code are only some of the aspects of working with data in a DB2 database. In this chapter, I'll introduce the supporting cast of objects that round out DB2's capabilities and provide some of its most subtle and powerful features.

Indexes are used to allow DB2 to provide fantastic performance with enormous amounts of data, as well as additional capabilities in query optimization and even data integrity.

Sequences cover a classic use pattern in data management: the need to generate numbers guaranteed to be unique based on a given algorithm or business rule.

Views are some of the oldest and most widely used features of any database. By providing ...

Get Beginning DB2: From Novice to Professional now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.