Answer to Question #71267 in Databases | SQL | Oracle | MS Access for Nasr nasser
(i) Give the initial query plan (constructed as in Lecture 12) for the SQL query
SELECT B, E, G
FROM R, S, T
WHERE A = 10 AND C = D AND E = F AND A > G;
Then use the heuristics from Lecture 16 to transform the initial query plan into an optimised
(logical) query plan. Perform the transformation step-wise, pushing a single operator over a
single operator in each step, and indicate the heuristics you apply.
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!