>>>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 >>>>>
Time: 3.804 SELECT TI.cTrans_fk as cTrans_pk, ; 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 Rushmore optimization level for intermediate result: none Rushmore optimization level for table t: none Joining intermediate result and table t using index tag Ctrans_fk Rushmore optimization level for intermediate result: none Rushmore optimization level for table ti: none Joining intermediate result and table ti using temp indexI'm running everything locally with SET DELETED ON.