Chapter 11, Problem 21P

Problems 17–21 are based on the following query:

SELECT	V_CODE, V_NAME, V_CONTACT, V_STATE
FROM	VENDOR
WHERE	V_STATE = 'TN'
ORDER BY	V_NAME;

Assume that you have 10,000 different products stored in the PRODUCT table and that you are writing a web-based interface to list all products with a quantity on hand (P_QOH) that is less than or equal to the minimum quantity, P_MIN. What optimizer hint would you use to ensure that your query returns the result set to the web interface in the least time possible? Write the SQL code.