Re: The order of fields around the "=" in the WHERE conditions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Mike Quinn" <mquinn@xxxxxxxxxxxxxxx>
Subject: Re: The order of fields around the "=" in the WHERE conditions
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 03 Apr 2006 17:35:07 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Mike Quinn" <mquinn@xxxxxxxxxxxxxxx> message dated "Mon, 03 Apr 2006 14:24:48 -0700"
In-reply-to: <44313030020000E5000001DA@xxxxxxxxxxxxxxxxxxxxxxx>
References: <44313030020000E5000001DA@xxxxxxxxxxxxxxxxxxxxxxx>

"Mike Quinn" <mquinn@xxxxxxxxxxxxxxx> writes:
> -- The order of fields around the "=" in the WHERE conditions
> -- affects the query plan.

That absolutely should not be happening.  Could we see a complete test
case?

			regards, tom lane

References:
- The order of fields around the "=" in the WHERE conditions
  - From: Mike Quinn

Prev by Date: The order of fields around the "=" in the WHERE conditions
Next by Date: Re: The order of fields around the "=" in the WHERE conditions
Previous by thread: The order of fields around the "=" in the WHERE conditions
Next by thread: Re: The order of fields around the "=" in the WHERE conditions
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux