4 ms·
Am I incorrect in stating that this isn't necessarily true? Just because a statement is earlier in a script doesn't mean it will be optimized first.
by atwebb 13y ago
Am I incorrect in stating that this isn't necessarily true? Just because a statement is earlier in a script doesn't mean it will be optimized first.
- joevandyk 13y agoIn Postgres, common table expressions are planned and executed separately. I think of it as each section builds a temp table. This can be a good or bad thing, but it's sometimes important to know that it's happening.