MySQL Performance: How To Leverage MySQL Database Indexing

Published: 22 October 2020
on channel: Liquid Web

314

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

Watch video MySQL Performance: How To Leverage MySQL Database Indexing online without registration, duration hours minute second in high quality. This video was added by user Liquid Web 22 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 314 once and liked it 3 people.

336