The JOIN ORDER FIXED hint specifies that the optimizer use tables in a join in the order listed in the FROM clause of the query. This means that the optimizer does not attempt to rearrange the join order and does not try to find alternate access paths to complete the join.
Example:
SELECT --(* vendor(SOLID), product(Engine), option(hint) -- JOIN ORDER FIXED *)-- * FROM TAB1, TAB2 WHERE TAB1.I >= TAB2.I