On Fri, Jul 12, 2013 at 3:58 AM, Elan Feingold <e...@plexapp.com> wrote:
> Just to update, we're attempting to move to a 3.8.0 snapshot, and we've > run into another possibly pathological case you might want to be aware of > (same schema). The query is... > Thanks for the follow-up report. The following is a simplified test case for readers who happen to be following along: CREATE TABLE t1(x INTEGER PRIMARY KEY, y INTEGER); CREATE INDEX t1y ON t1(y); EXPLAIN QUERY PLAN SELECT a.x, b.x FROM t1 AS a JOIN t1 AS b ON a.y=b.x WHERE (b.x=$xyz OR b.y=$xyz); The OR expression in the WHERE clause is not being exploited by the NGQP, resulting in slower performance. I understand the problem (it's complicated) and am working on a fix now. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
