ALTER TABLE TABLE_NAME ADD INDEX `index_name` (`column_name`)
## Adding an Index to Existing Table
CREATE INDEX indexName ON tableName (ID, LName, FName, LOC);
## Adding an Index to Existing Table with Primary Key
CREATE UNIQUE INDEX indexName ON tableName (ID, LName, FName, LOC);