On Wed, 2005-08-03 at 00:05 +0200, Martijn Voncken wrote: > I'm using pysqlite2,compiled against sqlite 3.2.1 > I thought that IN uses an index. >
Versions 3.2.2 and earlier only use IN in an index if the column on the left of the IN operator is the left-most column in the index. This constraint is relaxed in the latest code in CVS and in the next release. On Tue, 2005-08-02 at 15:41 -0700, Cory Nelson wrote: > BETWEEN doesn't use an index either. I have yet to get an > explaination for either of them :( > BETWEEN will use an index in the latest code in CVS which will appear in the next release. -- D. Richard Hipp <[EMAIL PROTECTED]>
