About the NOT PADDED Clause

To minimize any increase in storage when you migrate your database to Unicode, indexes in the Siebel Schema are defined with the NOT PADDED clause by default when you convert your storage control file to Unicode using the Siebel Database Storage Configurator as described in Converting the Storage Control File to Unicode.

When the NOT PADDED clause is specified:

• Varying-length columns of an index are not padded to their maximum length; DB2 stores only the key data, which reduces the storage required by the index key.

• VARGRAPHIC columns of an existing index are stored as varying-length columns.

  If the NOT PADDED clause is not specified, VARGRAPHIC columns are stored as fixed-length columns.

  You can specify that indexes are to be NOT PADDED by default by specifying the PADIX DSNZPARM. You can also use the PADDED or NOT PADDED clauses in the CREATE INDEX or ALTER INDEX statements to specify whether an individual index is padded or not.