Materialized View support in Vertica??

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Wed Nov 11, 2015 3:58 pm

Materialized View support in Vertica??

Post by majidtahir » Wed Nov 11, 2015 4:02 pm

Dear All,
Do vertica support materialized view? Can we create materialized views in it??

User avatar
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am

Re: Materialized View support in Vertica??

Post by JimKnicely » Wed Nov 11, 2015 5:51 pm


Vertica is so fast that you don't need materialized views :)

A projection in Vertica is like a materialized view. You can create multiple projections on the same table if you need to optimize for a particular query (i.e. changing the column sort order).

Here are the Projection types available: ... ctions.htm
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica SQL”