Since aggregates can't be part of a projection, would the performant approach in Vertica 7 be to create a projection with the summary key order, then create a view on top of that with the column SUMs? Or is the projection unnecessary?
Example:
CREATE TABLE source (key1, key2, key3, fact1);
CREATE PROJECTION summary_projection AS SELECT key1, key3, fact1 FROM source ORDER BY key1, key3;
CREATE VIEW summary_view AS SELECT key1, key3, SUM(fact1) GROUP BY key1, key3;