Data Partition - Vertical partitioning
1 - Table pruning though a view
- Create two tables with a column primary key
- Create a view joining this two tables through this key
- Selecting only columns of one tables must select only one table (pruning the second one).
2 - Reference
- A solution for a row-store solution, the vertical partitionning : How to tune access of "fat" tables