CSE Roadmap

Specialist tier · about 2 hours · 5 parts

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.