Based on the following query: SELECT P_CODE, SUM(LINE_UNITS) FROM LINE GROUP BY P_CODE HAVING SUM(LINE_UNITS) > (SELECT

Question:

Based on the following query:

SELECT        P_CODE, SUM(LINE_UNITS)

FROM          LINE

GROUP BY  P_CODE

HAVING       SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE);


Should you create an index? If so, what would the index column(s) be, and why would you create that index? If not, explain your reasoning.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: