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