Answer to Question #246915 in Software Engineering for samii

Question

Consider the following query:

Query 2:

SELECT c.RegNo, c.model, c.year, o.NIC

FROM cars c, owner o

WHERE c.RegNo=o.RegNo and year =2017 and price <6000000

1. Assume there are no indexes available on either table. If the join algorithm used is block nested loops join, draw the extended query plan for Query 2.

2. Calculate the cost of executing Query 2 using the plan designed in question 2. Show the steps in the calculation.

3. If the join algorithm used is Index nested loops join, what are indexes needed in order to have an optimal plan for Query 2?

4. Draw the extended query plan for Query 2 using identified indexes in question 4.

5. Calculate the cost of executing Query 2 using the plan designed in question 5. Show the steps in the calculation

Answer 1

Dear samii, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order