Partial Index

Databasesdb

The Question

What is a partial index and when would you use one?

What a Strong Answer Covers

• Index on a subset of rows
• WHERE condition in the index definition
• use case (e.g. pending transactions).

Related Questions

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