RE: [sqlite] Re: seeking answers for a few questions about indexes

> > EXPLAIN QUERY PLAN SELECT * FROM vals2d WHERE x = 1 OR y = 1; > > select * from vals2d where x=1 > union all > select * from vals2d where y=1 Super! You've greatly helped me yet again. My query really looked like this: SELECT x,y,val FROM vals2d WHERE x = 1 OR y = 1 ORDER BY val DESC

[sqlite] Re: seeking answers for a few questions about indexes

Brannon King wrote: I have a table: CREATE TABLE vals2d (x INTEGER, y INTEGER, val INTEGER); CREATE UNIQUE INDEX xy ON vals2d (x,y); EXPLAIN QUERY PLAN SELECT * FROM vals2d WHERE x = 1 OR y = 1; produces 0|0|TABLE vals2d The index is unused. Index on (x, y) allows an efficient search on