Which statement best contrasts horizontal sharding and vertical partitioning?

Problem Statement

Explanation

Horizontal sharding distributes different rows of the same table to multiple physical nodes to scale write and read throughput. Vertical partitioning separates columns by concern, often isolating wide or cold fields to another table or service for performance and cost control.

Code Solution

SolutionRead Only

users_shard_17 holds user_id hash 544..575; profile_wide moved to users_profile_ext

Practice Sets

This question appears in the following practice sets:

Database Sharding & Partitioning

Next Question

Master Interviews
Anywhere, Anytime

Which statement best contrasts horizontal sharding and vertical partitioning?

Problem Statement

Explanation

Code Solution

Practice Sets

Related Questions

Which statement best describes the Single Responsibility Principle?

Open–Closed Principle encourages what practice when adding features?

High-Level Design (HLD) typically focuses on which artifacts?

Which UML diagram best captures interactions over time between components?

Which pairing describes a healthy design goal?

More from System Design

Master Interviews Anywhere, Anytime

Which statement best contrasts horizontal sharding and vertical partitioning?

Problem Statement

Explanation

Code Solution

Practice Sets

Related Questions

Which statement best describes the Single Responsibility Principle?

Open–Closed Principle encourages what practice when adding features?

High-Level Design (HLD) typically focuses on which artifacts?

Which UML diagram best captures interactions over time between components?

Which pairing describes a healthy design goal?

More from System Design

Master Interviews
Anywhere, Anytime