Re: [sqlite] Re: perfomance degradation for expr "foo = X or bar =X"

On Wed, 9 May 2007 14:24:27 +0400 Tomash Brechko <[EMAIL PROTECTED]> wrote: > On Wed, May 09, 2007 at 14:03:54 +0400, bash wrote: > > Im simplify environment: > > > > CREATE TABLE tbl( > > id integer NOT NULL PRIMARY KEY AUTOINCREMENT, > > n1 int, > > n2 int > > ); > > CREATE INDEX

Re: [sqlite] Re: perfomance degradation for expr "foo = X or bar =X"

On Wed, May 09, 2007 at 14:03:54 +0400, bash wrote: > Im simplify environment: > > CREATE TABLE tbl( > id integer NOT NULL PRIMARY KEY AUTOINCREMENT, > n1 int, > n2 int > ); > CREATE INDEX idx1 on tbl(n1); > CREATE INDEX idx2 on tbl(n2); > > sqlite> select count(*) from tbl; >

[sqlite] Re: perfomance degradation for expr "foo = X or bar =X"

Im simplify environment: CREATE TABLE tbl( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, n1 int, n2 int ); CREATE INDEX idx1 on tbl(n1); CREATE INDEX idx2 on tbl(n2); sqlite> select count(*) from tbl; 63026 1 query: SELECT id, n1, n2 FROM tbl WHERE n1 = $I OR n2 = $I