Where is inline view created using "WITH" clause stored in memory ?

dsahu1

How to optimize a Left join which uses a view created using WITH clause with table that is segmented on a column ?

Bryan_H

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.