4 ms·
Yeah, I've also heard that claim being made on the mailing list but it is probably wrong: http://dba.stackexchange.com/questions/27425/is-the-optimisation-fence
by bjourne 14y ago
Yeah, I've also heard that claim being made on the mailing list but it is probably wrong: http://dba.stackexchange.com/questions/27425/is-the-optimisation-fence-behaviour-of-a-cte-with-query-specified-in-the-sql2 http://dba.stackexchange.com/questions/27425/is-the-optimisa.... For writable cte:s it matters, for read-only ones the number of execution times doesn't.
- pvh 14y agoSorta. It can be handy for guiding the optimizer away from a bad optimization choice but that's really a bad habit to get into.