Skip to content
loading...

re: SQL 201: Why you should use SQL CTEs VIEW POST

TOP OF THREAD FULL DISCUSSION
re: It’s a common misperception that CTE queries are staged in memory or are “persisted data sets”. Not true. They’re simply syntactic sugar that SQL w...
 

Very much RDBMS dependent in this respect, and I appreciate that this article and the responses focus on SQL Server.

In Oracle a CTE can be persisted by the query optimiser, and the decision is likely to be influenced by its expected size. The data is written to a temporary tablespace. Of course it is also unindexed.

code of conduct - report abuse