On 18 Jul 2010, at 11:34, Frans Bouma <fr...@sd.nl> wrote: > > One could argue to always do an FKSide LEFT JOIN PKside, even if the > fk side has no nullable fk fields, though it might be an RDBMS can > optimize the INNER JOIN better than the LEFT JOIN.
Yes - SQL compact will not rearrange tables in a queryplan when it has an outer join. Ironically, i've used this fact to force a more optimal queryplan by using an outer join in HQL. Richard
