Column encoding and compression type in manual projection design
In a performance tuning effort, we tried to redesign the projections. We started with DBD, but the design that DBD came up with didn't actually improve the query performance, compared to our current design. So we had to start the projection design manually. Are there any tools/functions we can use to determine the best encoding or compression types for all the columns if we know what columns will be in the SORT BY clause of the projection?