Adding final test: right outer join and left outer join seem to hit indices well. Although they don't have usually same execution plan (see 4/n/4/n)
Adding hibernate sample