On May 24, 2010, at 6:14 PM, Edzard Pasma wrote: > Hello, I found a blind spot of the query optimizer. This appears when > a table is accessed as a view. I think the problem can be phrased as > "the optimizer failing to push an outer join predicate into a > view"... This simply means that the following example does not use > the existing index: > > create table t (pk integer primary key); > create table t2 (fk); > create view v as select * from t; > select * from t2 left outer join v on pk = fk;
Not using the index because of point 3 on this list I would say: http://www.sqlite.org/optoverview.html#flattening _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
