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

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.