DeepFrontend
Learning Paths
Practice
System Design & DS
Design Studio
Data Structures Curriculum
Real-World Case Studies
Careers
Job Board
Resume Builder
Blog
Sign in
Search
⌘K
Go Pro
Loading compiler resources...
System Design Quiz Practice
Active Recall Drill Session
← Exit Session
Question 1 of 1
medium
System Design
A team's reads are slow on a database with no index on a frequently-filtered column. What's the highest-leverage first fix?
A
Add read replicas immediately
B
Add sharding immediately
C
Add an appropriate index on the frequently-filtered column — often a five-minute schema change that resolves the symptom directly
D
Switch database vendors entirely
Check Answer