17. Improving Database and Query Performance : Design Issues and Performance : Key Design and Performance : Characteristics of Good Keys
 
Share this page                  
Characteristics of Good Keys
Good keys have the following features:
Use columns referenced in the WHERE clauses and joins of your queries
Are unique
Always document reasons for maintaining non-unique keys.
All keyed storage structures can enforce unique keys. They are:
Short
Static
Non-nullable