In this collection · Understanding and improving performance

Relational databases · Planned article

Choosing indexes for your queries

This article hasn’t been written yet. This outline shows its place in the collection.

What this article will cover

Choose an access path for a particular query and workload.

Relate filters, ordering, column order, and coverage to index choices. Check the proposed benefit against an execution plan and the cost of writes.