I am a little confused over something regarding Rushmore.

The following two tables don't seem to optimize when I check with SYS(3054,11).

The two tables are not part of a database and belong to an very basic order entry system; tables are called order and orderitems.

Order has a character field called cOrderNum that is unique and does have an index on this field.

OrderItems does not have a unique field name, but does have a field also called cOrderNum that relates back to the Order table and also has an index.

When I do a:
SELECT * FROM Order, OrderItems WHERE Order.cOrderNum = OrderItems.cOrderNum

It takes a long time (not many records 10,000 orders; 20,000 OrderItems) 3 seconds.

SYS(3054) says that the query is not optimized and I don't see why!

TIA,
Mark