subject:"\\\[sqlite\\\] Re\\\: multi column select"

Re: [sqlite] Re: multi column select

2007-09-12 Thread RaghavendraK 70574

it! * - Original Message - From: Igor Tandetnik <[EMAIL PROTECTED]> Date: Wednesday, September 12, 2007 8:10 pm Subject: [sqlite] Re: multi column select > RaghavendraK 70574 > <[EMAIL PROTECTED]> wro

[sqlite] Re: multi column select

2007-09-12 Thread Igor Tandetnik

RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: Can anyone explain how does the below sql statmenent work, select * from tbl1 where a=xx and b=yy; when a is indexed and b is indexed seperately? The query can only use an index on one of the fields (the optimizer will try to guess which one).