>                 "DELETE FROM ConnectionEntity conn WHERE conn.stopOrPass.id 
> IN " +
>                     "(SELECT sop.id FROM StopOrPassEntity sop WHERE 
> sop.partialTrip.id IN " +
>                     "(SELECT prtTrip.id FROM PartialTripEntity prtTrip WHERE 
> prtTrip.trip.id IN : Ids))"

There have been performance problems in the past with IN (...) queries.

Is this query under your control? Or is it generated by some tool?

Reply via email to