alter table customers1 add index gender(gender);
alter table customers1 add index monthsalary(monthsalary);
show indexes from customers1;
alter table customers1 drop index gender;
alter table customers1 drop index monthsalary;
alter table customers1 add index gender_monthsalary(gender, monthsalary);