MediumApplyDatabase Scalingopen_ended

A company has a users table with 200M rows. Queries by user_id are fast but queries by email are slow. What is the solution?

Apply — Tests ability to use knowledge in practical scenarios.

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 21+ more Database Scaling questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the Database Scaling topic (System Design).

Learn Database Scaling→Browse All Questions

More Database Scaling Questions

What is the primary purpose of a read replica in a database setup?

Easy

In master-slave replication, replicas can accept write operations.

Easy

Which sharding strategy ensures that adding a new shard requires moving minimal data?

Medium-Easy

What is replication lag and why does it matter?

Medium-Easy

What is the difference between vertical partitioning and horizontal partitioning (sharding)?

Medium-Easy