>lcMfgr = "somevalue" >lcPtNo = "some value" > >SELECT * FROM invtmfhd WHERE partmfgr = lcMfgr >-----> Using index tag Partmfgr to rushmore optimize table invtmfhd > >SELECT * FROM invtmfhd WHERE mfgr_pt_no = lcPtNo >-----> Using index tag Mfgr_pt_no to rushmore optiomize table invtmfhd > >SELECT * FROM invtmfhd WHERE mfgr_pt_no = lcPtNo AND partmfgr = lcMfgr >----->Using index tag Mfgr_pt_no to rushmore optimize table invtmfhd >----->Using index tag Partmfgr rushmore optimize table invtmfhd>
>SELECT invtmfhd.uniqmfgrhd,crsTemp1.partmfgr,crsTemp1.mfgr_pt_no ; > FROM invtmfhd; > JOIN crsTemp1 ON invtmfhd.partmfgr = crsTemp1.partmfgr; > AND invtmfhd.mfgr_pt_no=crsTemp1.mfgr_pt_no; > INTO CURSOR crsTemp2 > >-----> Rushmore optimization level for table invtmfhd: none >-----> Rushmore optimization level for intermediate result: none>