Mira Suk <mira....@centrum.cz> wrote: >> Mira Suk wrote: >>> query written here is a lot simplified (for example "Points" column is >>> filtered using custom function) however main culprit >>> seems to be LEFT OUTER JOIN as accessing that same column in query which >>> only has B table in it is lightning fast. >>> >>> result of query is >>> just around 40 rows, (due to Parent filter) >> >> You may want an index on A(Parent) then. > > A.Parent is has Index
Ok then, show the result of prepending EXPLAIN QUERY PLAN to your statement. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users