MySQL Performance: How To Leverage MySQL Database Indexing

In this video, we demonstrate how to do leverage MySQL database indexing.

Commands used:
'show index from' tablename

CREATE TABLE tableName (
ID int,
LName varchar(255),
FName varchar(255),
DOB varchar(255),
LOC varchar(255),
INDEX ( ID )
);

CREATE TABLE tableName (
ID int,
LName varchar(255),
FName varchar(255),
DOB varchar(255),
LOC varchar(255),
PRIMARY KEY (ID),
UNIQUE INDEX ( ID )
);

CREATE INDEX indexName ON tableName (ID, LName, FName, LOC);

CREATE UNIQUE INDEX indexName ON tableName (ID, LName, FName, LOC);

DROP INDEX indexName ON tableName;

Video by: Justin Palmer