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 2m
- InnoDB vs MyISAM 3m
- B-Tree Index 2m
- Advantages of B-Tree Index 2m
- Clustered Index 1m
- Advantages of Clustered Index 1m
- Disadvantages of Clustered Index 1m
- Secondary Index 1m
- Building Clustered B-Tree 5m
- Building Secondary Index B-Tree 1m
- InnoDB Clustered Table 2m
- Hash Index 1m
- Limitation of Hash Index 1m
- Adaptive Hash Index 2m
- Building Hash Index 3m
- Other Indexes 1m
- Summary in Sixty Seconds 0m
- Introduction 1m
- Effectiveness of Index 1m
- Demo: List Indexes 3m
- Demo: Basics of Indexes 6m
- Demo: Order of Columns in Index 4m
- Demo: Optimize OR Conditions 7m
- Demo: Optimize OR Conditions - Advanced 8m
- Demo: Optimize AND Conditions 6m
- Demo: Optimize AND Conditions - Advanced 2m
- Demo: Cover Index 4m
- Demo: Clustered Index 8m
- Demo: Index Hints 5m
- Summary in Sixty Seconds 0m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.