Specifies that duplicates are compressed. If a sorted ranked
index allows duplicate entries, you can store many more records
in a small space when you compress duplicates, therefore,
minimizing I/O and increasing performance. Oracle Rdb uses
patented technology called byte-aligned bitmap compression
to represent the dbkeys for the duplicate entries instead of
chaining the duplicate entries together with uncompressed dbkeys.
Duplicates are compressed by default if you specify RANKED
without specifying the DUPLICATES ARE COMPRESSED clause.
You cannot use the DUPLICATES ARE COMPRESSED clause when you
create nonranked indexes or when you specify the UNIQUE keyword.
See the Oracle Rdb Guide to Database Design and Definition for
more information on sorted ranked B-tree indexes.