Course
Skills
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
MySQL Indexing for Performance
2mins
Types of Indexes
29mins
- 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
Indexing Strategies for High Performance
55mins
- 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
Index Maintenance
12mins
Checklists
3mins