General index attributes

You typically determine which type of index you need to define after you define a table space. An index can have many different attributes.

Index attributes fall into two broad categories: general attributes that apply to indexes on all tables and specific attributes that apply to indexes on partitioned tables only. The following table summarizes these categories.

Table 1. Index attributes
Table or table space type Index attribute
Any
  • Unique or nonunique
  • Clustering or nonclustering
  • Padded or not padded
  • Exclude nulls
Partitioned
  • Partitioning
  • Secondary

This topic explains the types of indexes that apply to all tables. Indexes that apply to partitioned tables only are covered separately.