Re: [sqlite] Different VDBE opcodes for the same query (part 2)

--- "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 > 1 order by > rowid; > 0|0|TABLE xxx USING PRIMARY KEY ORDER BY >

[sqlite] Different VDBE opcodes for the same query (part 2)

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 > 1 order by rowid; 0|0|TABLE xxx USING PRIMARY KEY ORDER BY The index is not used?! explain query plan select rowid, a, b, c from