| ▲ | yen223 9 hours ago | |
I've always thought of CTEs as a code organisation tool, not an optimisation tool. The fact the some rdbms treats them as an optimisation fence was a bug, not a feature. | ||
| ▲ | 6 hours ago | parent | next [-] | |
| [deleted] | ||
| ▲ | solumunus 8 hours ago | parent | prev [-] | |
Improved readability is definitely the primary benefit. | ||