IBM DB2 for Linux, Unix, and Windows Indexes

From DBArtisan
Jump to: navigation, search

Go Up to Indexes

IBM DB2 for Linux, Unix, and Windows 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.