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.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi