Chapter 11, Problem 28P

Problems 27 and 28 are based on the following query:

SELECT	P_CODE, P_DESCRIPT, P_QOH, P_PRICE, V_CODE
FROM	PRODUCT
WHERE	P_QOH < P_MIN
	AND P_MIN = P_REORDER
	AND P_REORDER = 50
ORDER BY	P_QOH;

What indexes would you recommend? Write the commands to create those indexes.