Running sys(3054,1) with the Left Outer Join shows:

Rushmore optimization level for table items: none
Rushmore optimization level for table cohead: none
Using index tag Invnum to rushmore optimize table invitems
Rushmore optimization level for table invitems: partial
Rushmore optimization level for intermediate result: none


Running sys(3054,1) with the Inner Join shows:

Using index tag Invnum to rushmore optimize table invitems
Rushmore optimization level for table invitems: partial
Using index tab Cb_id to rushmore optimize table items
Rushmore optimization level for table items: partial
Rushmore optimization level for table cohead: none