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).
- A solution for a row-store solution, the vertical partitionning : How to tune access of “fat” tables