Review six queries that require optimization . 1. SELECT Order.CustomerID, Product.ProductID, OrderDetail.OrderID FROM Product, OrderDetail, Order WHERE
Question:
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.
Auditing a risk based approach to conducting a quality audit
ISBN: 978-1133939153
9th edition
Authors: Karla Johnstone, Audrey Gramling, Larry Rittenberg