The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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
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.