Index Strategy · Hybrid
Index Strategy Studio
Design covering indexes, partial filters, and maintenance windows without turning tables into write-hostile forests.
- Duration
- 3 weeks · async + two live clinics
- Skill focus
- Advanced
- Platform lens
- PostgreSQL
- Tuition (informational)
- ₩1,240,000
Overview
You bring schema sketches; we stress-test them against read-heavy and write-heavy patterns. The course emphasizes trade-offs: fill factors, INCLUDE columns, and how to validate hypotheses with measured plans instead of folklore.
What is included
- Index sketch reviews with coach annotations
- Write amplification exercises on synthetic workloads
- Template for proposing rollbacks
- Office hours on partial indexes
- Peer review swap with another attendee
Outcomes
- Ship an index proposal with measured before/after plans
- List maintenance risks in plain language for release notes
- Pick partial vs full indexes using a simple decision tree
Primary coach
Min-jun Park
Builds progressive labs that mirror messy production traces, not toy datasets.
FAQ
Will we tune my employer schema?
You work on anonymized stand-ins. Sharing proprietary DDL in the forum is discouraged.
Are textbooks included?
Digital reader packets are included; printed binders are not.
Limitations?
Columnstore-specific guidance is out of scope for this cohort.
Experience notes
-
Our Index Strategy Studio workbook is pinned above my desk—the partial-index flowchart alone saved a messy rollout.
Tuition is informational on this static preview. Enrollment teams confirm availability, tax treatment, and any employer procurement paperwork steps. See Returns & Refunds for eligibility framing.