Answer all questions based on the following query:

SELECT V$\_$CODE, V$\_$NAME, V$\_$CONTACT, V$\_$STATE

FROM VENDOR

WHERE V$\_$STATE $=\text{'}$TN$\text{'}$

ORDER BY V$\_$NAME;

What indexes should you create and why? Write the SQL command to create the

indexes.