What is the difference between horizontal and vertical partitioning? - 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.