_____________________________________________________________
> Od: "Jim Morris"
> Komu:
> Datum: 22.09.2011 23:06
> Předmět: Re: [sqlite] LEFT JOIN optimization
>
> Your where clause "WHERE ItemsME.IDR ..." is only satisfied if there is
> an associated ItemsME record so the left outer join is pointless. Just
> use the inner join. Normally the left outer join would include all of
> ItemsME_Properties, that probably explains the table scan.
Yeah. the answer is I'm stupid. the left join was just for test sake (as was
said tables are 1:1 and IDR is unique) as I have all kinds of performance
problems with left outers. this one is on me not on SQLite lol - still would
say it's strange quirk - but the query is also strange.
Thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
