MySQL Performance: How To Leverage MySQL Database Indexing

Skip ad
13 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

LiquidWeb
Published
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-optimization-how-to-leverage-mysql-database-indexing/

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/dedicated/

Video by: Justin Palmer
Category
Liquid Web
Tags
liquidweb, datacenter, web
Be the first to comment