Here is a simple select statement:

select mtrandata.*,mtranitem.*,mtrancount.* ;
from mtrandata,mtranitem,mtrancount ;
where mtrandata.trandataid=mtranitem.trandataid and ;
mtranitem.trandataid=mtrancount.trandataid ;
INTO CURSOR TMPMERCH


Each of the tables have an index on TRANDATAID. When I run SYS(3054,11) it comes back with the following:

Rushmore optimization level for table mtrandata: none
Rushmore optimization level for table mtranitem: none
Rushmore optimization level for table mtrancount: none
Joining table mtranitem and table mtrancount using index tag Trandataid
Joining table mtrandata and intermediate result using temp index

I don't undertand why this join is not optimized. The fields joined are very simple and straight-forward.

Thank you for any help.