mark wrote:
> On Sat, Mar 15, 2008 at 5:04 PM, brian <brian(at)zijn-digital(dot)com> 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.