Question: Problem I An objective of this problem is to interpret a query processing plan created by a query optimizer and to draw a syntax tree

Problem I An objective of this problem is to interpret a query processing plan created by a query optimizer and to draw a syntax tree of a query processing plan Consider the following fragment of query processing plan. Consider the following fragment of query processing plan. | Id | Operation | Name I Rows | Bytes | TempSpc| Cost t ($CPU) | Time SELECT STATEMENT 134K 63M | 33989 (1) | 00:00:02 HASH JOIN 134K 63M | 51MI 33989 (1) 00 : 00 :02 HASH JOIN 135K | 50M I 1232K| 26145 (1 ) 00 : 00 :02 HASH JOIN 45 65 1172KI 2258 (1) 00 : 00:01 JOUIDWNH TABLE ACCESS FULL | PARTSUPP 4565 633K 1857 (1 ) 00 : 00 : 01 TABLE ACCESS FULL| PART 60000 7089KI 401 (1) | 00 :00 :01 TABLE ACCESS FULL LINEITEM 1800K 214MI 12160 (1) 00 : 00 :01 TABLE ACCESS FULL ORDERS 450KI 46M | 2697 (1) | 00 :00 :01 Predicate Information (identified by operation id) : access ("L_ORDERKEY"="O_ORDERKEY") access ( "LINEITEM" . "L PARTKEY"="P PARTKEY") access ( "PART" . "P_PARTKEY"="PS PARTKEY" ) GUI D WNH filter ("PARTSUPP" . "PS_SUPPLYCOST"100) filter ("LINEITEM" . "L PARTKEY">=0) Find and draw a syntax tree of the query processing plan listed above. To draw a syntax tree, use the relational algebra operations explained during the lecture classes. Assume that an operation HASH JOIN used in a query processing plan is the same as an operation JOIN in the relational algebra Deliverables A file solution 1.pdf with a drawing of syntax tree of a given query processing plan. TPC H benchmark database PART P_PARTKEY ID LINEITEM P_NAME QUANTITY P MFGR XTENDEDPRICE _BRAND DISCOUNT P TYPE TAX P_SIZE RETURNFLAG CONTAINER LINESTATUS RETAILPRICE SHIPDATE COMMENT COMMITDATE RECEIPTDATE SHIPINSTRUCT T-SHIPPED-BY PART ALOTY PS_A SHIPMODE COMMENT Includes[> PS_SUPPLYCOST PS COMMENT Supplies O. . 1 Contains SUPPLIER SUPPKEY ID L_LINENUMBER NAME ADDRESS PHONE ORDERKEY ACCTBAL ORDERSTATUS S_COMMENT TOTALPRICE 1 .." ORDERDATE Belongs-to 0000000 0 CORDERPRIORITY CLERK SHIPPRIORITY COMMENT NATION N_NATIONKEY ID 1 . . N_NAME COMMENT Submits Is-in CUSTOMER BUSTKEY TD NAME REGION ADDRESS 0000000 PHONE Belongs-to D R_REGIONKEY ID NAME ACCTBAL COMMENT KTSEGMENT COMMENT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
