Execute the following SQL and draw the query tree for the SQL. Describe what kinds of access

Fantastic news! We've Found the answer you've been seeking!

Question:

Execute the following SQL and draw the query tree for the SQL.

Describe what kinds of access methods are used for each table. Explain which join method is used in each join operation.

SELECT /*+ GATHER_PLAN_STATISTICS */ C.lname, S.address, Pr.name
FROM Customer C, Purchase Pu, Item I, Store S, Product Pr
WHERE C.id = Pu.cid AND Pu.pid = I.pid AND Pu.ino = I.no AND I.sid = S.id AND I.pid = Pr.id
AND C.fname = 'Tesla';
SELECT * FROM TABLE (DBMS_XPLAN.display_cursor (format=>'ALLSTATS LAST'));