- Course
MySQL Indexing for Performance
MySQL course focusing on Indexing Strategies for High Performance Database
Intermediate
- Course
MySQL Indexing for Performance
MySQL course focusing on Indexing Strategies for High Performance Database
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of Indexes and further explore practical tips and tricks for performance tuning.
MySQL Indexing for Performance
Intermediate
Table of contents
-
Introduction | 1m 32s
-
InnoDB vs MyISAM | 3m 20s
-
B-Tree Index | 1m 30s
-
Advantages of B-Tree Index | 2m 5s
-
Clustered Index | 42s
-
Advantages of Clustered Index | 1m 9s
-
Disadvantages of Clustered Index | 1m 6s
-
Secondary Index | 38s
-
Building Clustered B-Tree | 4m 47s
-
Building Secondary Index B-Tree | 1m 9s
-
InnoDB Clustered Table | 2m 22s
-
Hash Index | 1m 6s
-
Limitation of Hash Index | 1m 19s
-
Adaptive Hash Index | 1m 49s
-
Building Hash Index | 2m 31s
-
Other Indexes | 1m 23s
-
Summary in Sixty Seconds | 26s
Pinal Dave is a Pluralsight Developer Evangelist.