xxxxxxxxxx
CREATE TABLE emp_details (
id INT,
full_name VARCHAR(50),
email VARCHAR(50),
mobile INT NOT NULL,
PRIMARY KEY (id),
INDEX (id, email)
);
xxxxxxxxxx
CREATE INDEX index_name ON table_name(column1, column1,);
CREATE INDEX idx_uname ON users (first_name, last_Name);
ALTER TABLE users DROP INDEX idx_uname