Support for indexes that exclude NULL keys

In Db2 11, you can improve the performance of an index by excluding NULL keys from an index to reduce its size.

NULL key columns add to the size of an index and can reduce the performance of index scans. If you exclude NULL key columns from an index, Db2 creates index entries only for key columns that are not null. You can specify that an index excludes NULL keys when you create an index by using the CREATE INDEX statement.