Composite Index + Prefix Rule

Databasesdb

The Question

What is a composite index and how does the prefix rule apply?

What a Strong Answer Covers

• Leftmost prefix rule.

Related Questions

• ACID
• Indexes
• Clustered vs Non-clustered
• Isolation Levels
• Normalization