Data Engineer 면접 질문과 답변

Question: What is the difference between horizontal and vertical partitioning in database design?

Answer: Horizontal partitioning divides a table into smaller tables with the same columns but different rows, while vertical partitioning divides a table into smaller tables with fewer columns but the same rows.

Example:

Horizontally partitioning a customer table based on regions, and vertically partitioning it based on customer information and order information.