Table of Contents

Search

  1. Preface
  2. Introduction
  3. The Design Issues
  4. Standard Population Choices
  5. Parsing, Standardization and Cleaning
  6. Customer Identification Systems
  7. Fraud and Intelligence Systems
  8. Marketing Systems
  9. Simple Search
  10. Composite Keys
  11. Summary

Application and Database Design Guide

Application and Database Design Guide

Guidelines to Generate Composite Keys

Guidelines to Generate Composite Keys

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.

0 COMMENTS

We’d like to hear from you!