To specify a combination of the various types of compression, add together the appropriate numbers. For example, 3 specifies duplicate key compression and leading character compression.
Note:
Trailing space compression and trailing null compression are mutually exclusive.
The KEYCOMPRESS parameter affects key compression for all indexes belonging to the file.
Comments:
To specify a combination of the various types of compression, add together the appropriate numbers. For example, 3 specifies duplicate key compression and leading character compression.