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;
The related article for this video can be found here: https://www.liquidweb.com/kb/mysql-op...
For more information about this and other topics, visit us at https://www.liquidweb.com/kb/ or for more information on our line of dedicated servers, visit: https://www.liquidweb.com/products/de...
Video by: Justin Palmer
