Superprojection
A projection that includes all columns in an anchor table.
A projection that includes all columns in an anchor table. Vertica uses superprojections to ensure support for all queries and other DML operations.
Under certain conditions, Vertica automatically creates a table's superprojection immediately on table creation. Vertica also creates a superprojection when you first load data into that table, if none already exists.
CREATE PROJECTION
can create a superprojection if it specifies to include all table columns. A table can have multiple superprojections.
For more information, see Creating projections.