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

SELECT

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

FROM

VENDOR

WHERE

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

ORDER BY

V$\_$NAME;