Horizontal vs Vertical Partitioning

Difficulty: Intermediate

Question

What is Vertical Partitioning?

Answer

Splitting a table into multiple tables with fewer columns (e.g., moving large 'blob' columns to a separate table that is less frequently accessed).

Concepts covered

Scaling, Manageability