Based on the following query: SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATE FROM PRODUCT P, VENDOR V WHERE

Question:

Based on the following query:

SELECT        P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATE

FROM          PRODUCT P, VENDOR V

WHERE        P.V_CODE = V.V_CODE

     AND        V_STATE = ‘NY’

     AND        V_AREACODE = ‘212’;

ORDER BY   P_PRICE;


What indexes would you recommend?

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

Step by Step Answer:

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