The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Where is inline view created using "WITH" clause stored in memory ?
How to optimize a Left join which uses a view created using WITH clause with table that is segmented on a column ?
Tagged:
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Hi, Common Table Expressions (CTE's, or "WITH clauses") are not materialized by default. Please see latest documentation about CTE's including info on materialization of queries at https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Statements/WITHClause.htm?zoom_highlight=Materialization
Please note that this is a relatively new change in Vertica and may not be available in earlier versions.