Objective: Write a correct customer-order join and explain what evidence is needed to evaluate its execution plan in Oracle 26ai.
This optional exercise replaces historical RBO table-positioning rules with modern join reasoning. There is no universally correct first or last table position that guarantees the best plan.