Problems $22-24$ are based on the following query:

SELECT FROM WHERE

P$\_$CODE, $\_$DESCRIPT, P$\_$PRICE, P$.$V$\_$CODE, V$\_$STATE PRODUCT P$,$ VENDOR V

P$.$V$\_$CODE $=$ V$.$V$\_$CODE

AND V$\_$ STATE $=$ NY

AND V$\_$AREACODE $=212\text{'}$

ORDER BY

P$\_$PRICE;

$1.$What indexes would you recommend?

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

$3.$Write the command$($s$)$ used to generate the statistics for the PRODUCT and VENDOR tables.