If set forceplan on is in effect, and query association is also enabled for the session, forceplan is ignored if a full abstract plan is used to optimize the query. If a partial plan does not completely specify the join order:
First, the tables in the abstract plan are ordered, as specified.
The remaining tables are ordered as specified in the from clause.
The two lists of tables are merged.