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.