> 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.
>--
>Igor Tandetnik
A.Parent is has Index
query
SELECT IDI FROM A WHERE Parent = ?
is fast - aka this have nothing to with that condition. IMHO only with result
column from B table.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
