Home /
Expert Answers /
Computer Science /
q5-apply-heuristic-query-optimization-to-optimize-the-given-query-show-all-the-five-steps-exp-pa257
(Solved): Q5. Apply Heuristic Query Optimization to optimize the given query. Show all the five steps exp ...
Q5. Apply Heuristic Query Optimization to optimize the given query. Show all the five steps explicitly with supporting query tree. (10 Marks) Query: SELECT C.CNAME, CC.CUSTNAME, CC.CUSTPUR FROM COUNTRY C, CUSTOMER CC WHERE CC.CUSTPUR AND C.CNAME "INDIA" AND C.CCODE CC.CCODE;
Expert Answer
Solution:-Step 1: Parsing the queryThe given SQL query can be parsed as follows:SELECT C.CNAME, CC.CUSTNAME, CC.CUSTPURFROM COUNTRY C, CUSTOMER CCWHER