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 31 is used?
SELECT
CUS_CODE, MAX(LINE_UNITS*LINE_PRICE)
FROM
CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINE
WHERE
CUS_AREACODE ='615'
GROUP BY
CUS_CODE;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!