A CTE is defined WITH cte AS (SELECT …). Which statement about CTEs is true?
SQL Data AnalystHard
SQL Data Analyst — Hard
A CTE is defined WITH cte AS (SELECT …). Which statement about CTEs is true?
Explanation
In most databases CTEs are not guaranteed to be cached; they may be inlined and re-executed per reference, though some engines (e.g., PostgreSQL with MATERIALIZED) allow explicit caching.
