Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between horizontal and vertical partitioning?

April 26, 2017difference horizontal partitioning vertical

0

10 Posted

What is the difference between horizontal and vertical partitioning?

1 Answer

0

10 Posted

Horizontal partitioning partitions or segments rows into multiple tables with the same columns. On the other hand, vertical partitioning segments columns into multiple tables containing the same rows. E.g. of horizontal partitioning :- customers with pin codes less than 50000 are stored in CustomersEast, while customers with pin codes greater than or equal to 50000 are stored in CustomersWest. Here the two partitioning tables can be East and west. E.g. of horizontal partitioning: – Splitting of dynamic data and static data.