Vertica Analytics Platform Version 9.2.x Documentation
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 Designing Projections.
Was this topic helpful?