mark wrote:
On Sat, Mar 15, 2008 at 5:04 PM, brian <brian@xxxxxxxxxxxxxxxx> wrote:
As there's an index on id would it be faster to transpose the WHERE
conditions?
WHERE id > your_last_id
AND session_key IS NOT NULL
I can't remember if the order of WHERE is significant.
brian,
i have an index on session_key also
Yeah, I should have asked, "If there's just the index on id ..."
> but i dont have a session key combined on both. should i do that?
I'll defer to someone with more insight.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
