Rearranging the order of tables in a FROM clause
The order of tables or views in the FROM CLAUSE can affect the access path that Db2 chooses for a SQL query.
About this task
If your query performs poorly, it could be because the join sequence
is inefficient. You can determine the join sequence within a query block from
the PLANNO column in the PLAN_TABLE. If you think that the join sequence is
inefficient, try rearranging the order of the tables and views in the FROM
clause to match a join sequence that might perform better. 