Composite indexes and column order

Coming soon
IntermediateDifficulty: Intermediate
DeveloperAudience: Developer
DevOps / SREAudience: DevOps / SRE
Store and process dataPurpose: Store and process data

Wave 5 · Atomic details and verification · T40.03

Coming soon — this article is being prepared. Below are its question, intended outcome, and place in the story.

The question

How can you test composite-index column-order effects?

What we will work through

Test composite-index column-order effects.

Before you begin

Previously covered: B-tree indexes; EXPLAIN and EXPLAIN ANALYZE.

Articles

Color theme

Language

Home