Expalin which plan will give the best perfomance and why

Assignment Help Computer Engineering

Reference no: EM132116090

Query Plan. Pleas draw 3 different querry plans(trees) for the following SQL. Statement and schema. you have to write the necessary table names and column names as the tree node and leafs. Italicized and Bold words means foreign key.

Custmoer(customer_id, login_id, password,first_name, last_name,tel,address, city,zipcode,state)

producct(product_id, name, description, vendor_id, cost, sell_price, quantity,employee_id)

Orders(order_id,customer _id, date)

Product_order(order_id, product_id, quantity)

select c.first_name, p.name,po.qunatity,o.date

from Customer c, Product p. Product_order po, orders o

where p. product_ id=po.product_id and po.order_id=o.order_id and

c.customer_id=o. customer_id and c.last_name='test';

3.1 Query plan 1 (draw).

3.2 Qurey plan 2 (draw).

3.3 Query plan 3 (draw)

3.4 please expalin which plan will give the best perfomance and why?

Reference no: EM132116090

Questions Cloud

Compute the present value of 10 monthly payments : Compute the present value of 10 monthly payments of $5000 (the first payment made 1 month from today).

Create a decision tree illustrating the cost and probability : Create a decision tree illustrating the cost and probability of each option and then identify the best decision for the project.

What is the project npv if the tax rate is 30 : The annual operating cash flow is $70132 and the cost of capital is 5% %?What is the project's NPV if the tax rate is 30

Explain your thought process to the class : Explain your thought process to the class. Be sure to mention a reasonable due date and responsible party.

Expalin which plan will give the best perfomance and why : Draw 3 different querry plans(trees) for the following SQL. Statement and schema. you have to write the necessary table names.

Financial statement information for the zamboni icers : Consider the following financial statement information for the Zamboni Icers Corporation:

Critically analyse security issues in healthcare networks : Analyse critically, three security issues in Healthcare Networks. These issues should be taken from the current state of the art literature

Write a method that returns the index of the second element : Write a method that returns the index of the second smallest element in an array of integers.

How many times the loop calculate is going to be executed : For the following assembly code, how many times the loop ‘calculate' is going to be executed? Why?

User Account

All Pages