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 invtmfhdBut if I try to JOIN I get
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: noneCan somebody please educate me on why the tags don't get referenced and how I might be able optimize the query?