I simply cannot understand when or in what situation will we ever choose vertical partitioning instead of horizontal partitioning.
What are the benefits of vertical partitioning VS horizontal partitioning?
Are there any examples of websites / companies / anyone that uses vertical partitioning and what is/will be the main reason for that decision?
I totally agree with what Darhazer has said.
There are two major forms of partitioning:
- Horizontal Partitioning - this form of partitioning segments table rows so that distinct groups of physical row-based datasets are formed that can be addressed individually (one partition) or collectively (one-to-all partitions). All columns defined to a table are found in each set of partitions so no actual table attributes are missing. An example of horizontal partitioning might be a table that contains ten years worth of historical invoice data being partitioned into ten distinct partitions, where each partition contains a single year's worth of data.
- Vertical Partitioning - this partitioning scheme is traditionally used to reduce the width of a target table by splitting a table vertically so that only certain columns are included in a particular dataset, with each partition including all rows. An example of vertical partitioning might be a table that contains a number of very wide text or BLOB columns that aren't addressed often being broken into two tables that has the most referenced columns in one table and the seldom-referenced text or BLOB data in another
Copied from http://mysql.localhost.net.ar/tech-resources/articles/performance-partitioning.html
