(Iggy Fernandez) An execution plan is a tree. This is not very obvious from the listing of DBMS_XPLAN or EXPLAIN PLAN but some pictures will illustrate the point (click on them to enlarge them). The following query joins the Employees table to the Jobs, Departments, Locations, Countries, and Regions
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help