How to optimize a Left join which uses a view created using WITH clause with table that is segmented on a column ?
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.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.