--- "Sergey M. Brytsko" <[EMAIL PROTECTED]> wrote:
> Hi All!
>
> The DB schema is:
> CREATE TABLE xxx(a TEXT, b INTEGER, c TEXT);
> CREATE INDEX idx on xxx(b);
>
> explain query plan select rowid, a, b, c from xxx where b > 10000 order by
> rowid;
> 0|0|TABLE xxx USING PRIMARY KEY ORDER BY
> The index is not used?!
sqlite> explain query plan select rowid, a, b, c from xxx where b > 10000;
0|0|TABLE xxx WITH INDEX idx
sqlite> explain query plan select rowid, a, b, c from xxx where b > 10000 order
by +rowid;
0|0|TABLE xxx WITH INDEX idx
____________________________________________________________________________________Get
the Yahoo! toolbar and be alerted to new email wherever you're surfing.
http://new.toolbar.yahoo.com/toolbar/features/mail/index.php
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
