with statement

yang · Post by **yang** » Wed Jul 25, 2012 3:07 am

Is there anything like the `with` statement available in Vertica? (I.e. like subqueries but reusable, avoiding creating temp tables.)

id10t · Post by **id10t** » Wed Jul 25, 2012 6:43 am

Hi yang!

>> Is there anything like the `with` statement available in Vertica?
No

>> avoiding creating temp tables
Views?
Projections? If you !can create appropriate projection - a query will return quickly.

with statement

with statement

Re: with statement