if you are running CBO then the optimizer determines the order in which the tables are processed