Materialized View support in Vertica??

Moderator: NorbertKrupa

Post Reply
majidtahir
Newbie
Newbie
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
JimKnicely
Site Admin
Site Admin
Posts: 1804
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Materialized View support in Vertica??

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

Hi,

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:

http://my.vertica.com/docs/7.2.x/HTML/i ... ctions.htm
Jim Knicely

Image

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”