Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain why a secondary index does not automatically inherit the primary partitioning scheme.
- Compare partitioning a secondary index by document versus by term.
- Define a scatter-gather query, and explain when each indexing approach needs one.
- Choose a secondary-indexing approach for a described query pattern.
The previous page covered partitioning the main dataset by its primary key. This page covers a complication that arises as soon as a query needs to look things up by a different column. A secondary index needs its own partitioning decision, and that decision shapes exactly how expensive a query on that index becomes.