A la lecture du paragraphe ci-dessous,
source : http://download.oracle.com/docs/cd/B...mops.htm#51003
A join order is the order in which different join items, such as tables, are accessed and joined together. For example, in a join order of table1, table2, and table3, table table1 is accessed first. Next, table2 is accessed, and its data is joined to table1 data to produce a join of table1 and table2. Finally, table3 is accessed, and its data is joined to the result of the join between table1 and table2.
L'ordre des tables dans la requete est déterminant pour désigner la table directrice lors de la génération du plan d'execution, n'est ce pas ?

Merci de votre interprétation