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; I hope I may call this a shortcoming of the optimizer and that it will be changed is some future version. Best regards, Edzard. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users