Review six queries that require optimization .

1. SELECT Order.CustomerID, Product.ProductID, OrderDetail.OrderID

FROM Product, OrderDetail, Order

WHERE Order.OrderID = OrderDetail.OrderID AND OrderDetail.ProductID = Product.ProductID AND OrderDetail.Price = 50

a. Optimize query performance using appropriate strategies (that is, optimizer hints, additional indices, changing the query search arguments, or some combination thereof as appropriate).

b. Explain briefly why you chose the strategies that you employed.

2. SELECT Order.CustomerID, Product.ProductID, OrderDetail.OrderID

FROM Product, OrderDetail, Order

WHERE Order.OrderID = OrderDetail.OrderID AND OrderDetail.ProductID = Product.ProductID AND CustomerID < 100 AND Quantity = 1

a. Optimize query performance using appropriate strategies (that is, optimizer hints, additional indices, changing the query search arguments, or some combination thereof as appropriate).

b. Explain briefly why you chose the strategies that you employed.

3. SELECT Customer.FirstName, Customer.LastName, Product.ProductName, OrderDetail.Quantity, OrderDetail.Price

FROM Customer, Order, OrderDetail, Product

WHERE Customer.CustomerID = Order.CustomerID

AND Order.OrderID = OrderDetail.OrderID

AND OrderDetail.ProductID = Product.ProductID

AND ProductID NOT IN (1, 2, 3, 4, 5, 6, 7)

a. Optimize query performance using appropriate strategies (that is, optimizer hints, additional indices, changing the query search arguments, or some combination thereof as appropriate).

b. Explain briefly why you chose the strategies that you employed.