Chapter 11, Problem 23P

Problems 22–24 are based on the following query:

SELECT	P_CODE, P_DESCRIPT, P_PRICE, P.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;

Write the commands required to create the indexes you recommended in Problem 22.