Question: How would you rewrite the query to ensure that the index you created in Problem 3 1 is used? SELECT CUS _ CODE, MAX (
How would you rewrite the query to ensure that the index you created in Problem is used?
SELECT
CUSCODE, MAXLINEUNITSLINEPRICE
FROM
CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINE
WHERE
CUSAREACODE
GROUP BY
CUSCODE;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
