But MySQL is only doing full table scans on the cust_order table because we don't have suitable indexes, and I do not do a full table scan of order_line because I have an index I can use to avoid that ...