Problems are based on the following query: SELECT                                  P_CODE, P_DESCRIPT, P_PRICE, P.V_CODE, V_STATE FROM                                    PRODUCT P, VENDOR V WHERE                                 P.V_CODE = V.V_CODE AND V_STATE = 'NY' AND V_AREACODE = '212' ORDER BY                            P_PRICE; What indexes would you recommend?

USE this part to write SQL statements at the bottom questions 1-11   Branch(branch_id:integer, branch_name:varchar(50), branch_location:varchar(40), money_on_hand:numeric(15,2)       create table Branch             (branch_id                              integer,     branch_name                                 varchar(50),     branch_location                 varchar(40),     money_on_hand                 numeric(15,2),     primary key (branch_id));   Loan(loan_number:integer, branch_id:integer, amount:numeric(8,2))                   foreign key branch_id references Branch(branch_id)   create table Loan       (loan_number            integer,     branch_id                                  integer,     amount                                     numeric(8,2),     primary key (loan_number),     foreign key (branch_id) references Branch (branch_id));   Customer(customer_id:integer, customer_last_name:varchar(35),customer_first_name:varchar(25), customer_street:varchar(30),…