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.

Is it helpful? Yes No

Most helpful rated by users:

What is a schema in the context of databases?
Explain the concept of ETL in the context of data engineering.