- Course
- Data
MySQL Indexing for Performance
MySQL course focusing on Indexing Strategies for High Performance Database
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.
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
About the author
Pinal Dave is a Pluralsight Developer Evangelist.