Re: faster SELECT

On Monday 08 March 2004 09:41, sferriol wrote:
> hello
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
>
> for example
> 1) select ... where a and b;
> 2) select ... where b and a;
>
> 1 and 2 will use the same cpu time or not ?

I really wouldn't worry about it, for two reasons.
1. The difference in timing is going to be negligible (probably not
measurable).
2. The developers might change their mind about evaluation order, in which
case you've wasted your time optimising.

--
  Richard Huxton
  Archonet Ltd