Consider the following guidelines when you generate composite keys:
To improve search performance, specify two or three
fields for generating a composite key even though you can include keys of up to
five fields. Including more fields in a composite key might impact
performance.
The key size is 8 bytes for fields such as
Person_Name
,
Address_Part1
, and
Organization_Name
. The key size is 16 bytes for fields such
as
Code
and
Telephone_Number
.
The size of a
composite key is computed by adding the key sizes of all fields. For
example, if you generate a composite key by combining the Person_Name and
Address_part1 fields that have 8 bytes each, the size of the composite key
is 16 bytes. If you generate a composite key with the Person_Name and
Telephone_Number fields that have 8 and 16 bytes respectively, the size of
the composite key is 24 bytes.