Views and Projections

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Views and Projections

Post by Julie » Wed Aug 01, 2012 3:03 am

Hi guys,

When I create a view are there new projections created or are the ones that already exists for the tables included in the view used? I'm curious if creating views will increase the amount of raw data that counts against our 2 GB license limit!

:)
Thanks,
Juliette

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Views and Projections

Post by jpcavanaugh » Wed Aug 01, 2012 3:06 am

Views are not new storage, the engine just does a query rewrite on the fly

User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Re: Views and Projections

Post by Julie » Wed Aug 01, 2012 3:17 am

juniorfoo,

Thanks! That's what I thought.

(and thanks for the quick response!)
Thanks,
Juliette

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Views and Projections

Post by jpcavanaugh » Wed Aug 01, 2012 3:18 am

Glad to help :)

Post Reply

Return to “New to Vertica Database Administration”