Dear All,
Do vertica support materialized view? Can we create materialized views in it??
Materialized View support in Vertica??
Moderator: NorbertKrupa
-
- Newbie
- Posts: 1
- Joined: Wed Nov 11, 2015 3:58 pm
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Materialized View support in Vertica??
Hi,
Vertica is so fast that you don't need materialized views![Smile :)](./images/smilies/icon_e_smile.gif)
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
Vertica is so fast that you don't need materialized views
![Smile :)](./images/smilies/icon_e_smile.gif)
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](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.