IBM DB2 for OS/390 and z/OS Indexes

Go Up to Indexes

IBM DB2 for OS/390 and z/OS offers two types of indexes:

• Unique
• Non-Unique

Unique Indexes guarantee that no two rows of a table have duplicate values in the columns that define the index.

Non-Unique indexes let table rows have duplicate values in the columns that define the indexes.