IQ UNIQUE and MINIMIZE_STORAGE

Using IQ UNIQUE and MINIMIZE_STORAGE can save disk space and improve performance.

Use IQ UNIQUE and MINIMIZE_STORAGE whenever possible to help minimize storage usage for the default FP index types. By default, optimal data compression is not enabled via these options which can lead to some additional space consumption. Employing either of these options in the data model helps compress the data as much as possible to achieve maximum storage and performance.

Related concepts
Indexing Tips
When and Where to use Indexes
Simple Index Selection Criteria
HG Index Loads
Multi-Column Indexes
Join Column
Primary Keys
Foreign Keys
Proper Data Type Sizing
Null Values
Unsigned Data Types
LONG VARCHAR and LONG VARBINARY
Large Object Storage
Temporary Tables
Denormalizing for Performance
UNION ALL Views for Faster Loads