It's correct. You cannot have filter Rushnmore optimization w/o filter condition. To see Rushnmore optimization for JOINS, you have to use SYS(3054,11)

I have a table INVTMFHD with separate index tags on (among others) fields PARTMFGR and MFGR_PT_NO. If I do....

>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

>
>But 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: none

>
>Can somebody please educate me on why the tags don't get referenced and how I might be able optimize the query?
>
>Thanks to all..........Rich