Composite Indexes

← Back to Indexing

Indexes on multiple columns. The leftmost prefix rule determines which queries can use the index effectively.

Key Properties

• Multi-Column Indexing
• Leftmost Prefix Rule

---

relational-databases indexing composite