WHERE order
Started by Rod Taylorover 22 years ago2 messageshackers
It would appear that in 7.4 the order of clauses in WHERE affects the
execution time (not output if AND).
I would think that a simple optimization would be to push off evaluation
of a subplan whenever possible by re-arranging AND statements.
In the below example, it gives an order of magnitude speed increase on a
small dataset.
Re: WHERE order
Rod Taylor <rbt@rbt.ca> writes:
I would think that a simple optimization would be to push off evaluation
of a subplan whenever possible by re-arranging AND statements.
Thought we did that already ... [ checks code ] ... hmph, it looks like
this is done correctly for quals attached to a scan node, but not for
quals attached to a join node. Oops.
regards, tom lane