Senior Backend Engineer / Stage 2 · Data
Select a B-tree and order its columns
"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- Not done7 min
- Not done5 min
- Not done9 min
- Not done5 min