>>>>>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 index && !!!! temp index !!!!! > >>>
> >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 into cursor curTemp1 > >*expected >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 index tag Ctrans_fk > >
Time: 0.260 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 index tag Ctrans_fk