Senior Backend Engineer / Stage 2 · Data

Select a B-tree and order its columns

CoreIntermediateDraft, not yet reviewed26 min of activities

"Already know" meets prerequisites. "Not relevant" removes the topic from your total but leaves what builds on it waiting.

Self-check

  • You query orders by customer ID and a created-at range, sorted newest first. Choose a composite B-tree order and compare it with the reversed order in the linked tuning exercises.
  • Evidence to include: Record the actual plan you ran. Explain the leading-column choice and write/storage costs without inventing measurements.

Try it without the material first, then compare. Save your answer in your notes below. Report a problem with this self-check

Learning activities

4 activities

My notes

Saved on this device, synced when signed in
Esc
↑ ↓ to move↵ to open