3 ms·
> postgres' query planner isn't clause-order invariant. i.e. a AND b won't necessarily give you the same query plan as b AND a. Do you have any references whic
by tirumaraiselvan 6y ago
> postgres' query planner isn't clause-order invariant. i.e. a AND b won't necessarily give you the same query plan as b AND a.
Do you have any references which shows this behaviour? Or a way to reproduce it?
- ris 6y agoNot to hand, but it's not amazingly hard to reproduce. You just have to build quite a complex query (many joins in our case) and play around with the clauses, watching the EXPLAIN output.