4 ms·
Very interesting idea... Perhaps a way to describe the sets of columns (clusters) and maybe even whether the cluster is row or column-oriented. But if you want
by chrisjc 4y ago
Very interesting idea... Perhaps a way to describe the sets of columns (clusters) and maybe even whether the cluster is row or column-oriented.
But if you want to split the table between frequently and rarely accessed sets of columns you could just use a view to bring different types of tables together? Eg: a view that brings a row-oriented table together with a column-oriented one? Or row-oriented table together with an external table (storage).
Obviously, DMLs would then become a little more complicated.
- kevincox 4y agoYeah, you can do this manually. In many cases probably almost as efficiently. But having this done with only a small configuration would be very powerful.