>>I have trust in this
>>

>>SELECT TI.cTrans_fk, TI.cInsurances_fk;
>>    FROM (select curTemp.cTrans_pk , max(T.iSequence_Number) iSequence_Number;
>>	    	from curTemp JOIN Trans_Insurances T ON curTemp.cTrans_pk = T.cTrans_fk ;
>>		    GROUP BY 1) X ;
>>		    JOIN Trans_Insurances TI ;
>>                 ON TI.cTrans_fk = X.cTrans_pk AND TI.iSequence_Number = X.iSequence_Number;
>> into cursor curTemp1
>>

>
>Seems to be a little bit faster, but still quite slow...

post sys(3054) and current exec time