Hi,

I have the following problem:
I have a query which is quick in SQL but extremely slow in HQL.
the structure is like this:

select
...
from
myTable
left outer join tableA as TA1 on myTable.id = TA1.owner_id
left outer join tableB as TB1 on TA1.id = TB1.owner_id
left outer join tableA as TA2 on myTable.id = TA2.owner_id
left outer join tableB as TB2 on TA2.id = TB2.owner_id
left outer join tableA as TA3 on myTable.id = TA3.owner_id
left outer join tableB as TB3 on TA3.id = TB3.owner_id
where
TB1.name='name1'
and TB2.name = 'name2'
and TB3.name='name3'

The size of the tables is cca:
myTable: 20.000
tableA : 3.000.000
tableB : 10.000

Thanks in advance:
Bianca