Lesson 18 of the SQL Optimization Course: Understanding Prefix Indexes
Explore how MySQL prefix indexes optimize query performance and storage efficiency.
ytt
Read More
5 min
Category: Course
28 posts
Lesson 17 of the SQL Optimization Course: Understanding Hash Tables
Explore hash tables and MySQL hash indexes to optimize database performance and improve query efficiency.
ytt
Read More
5 min
Lesson 16 of the SQL Optimization Course: Primary Key Design
Explore MySQL primary key design best practices, including space efficiency, ordering, data types, and alternatives to UUIDs for optimal performance.
ytt
Read More
7 min
Lesson 15 of the SQL Optimization Course: Index Design (MySQL Index Structures)
Explore the index structures of MySQL's MyISAM and InnoDB engines, their advantages, disadvantages, and optimization strategies for database performance.
ytt
Read More
8 min
Lesson 14 of the SQL Optimization Course: Index Design (B+ Tree Organization)
B+ Trees optimize database indexing by reducing disk I/O and improving query efficiency. Learn how they power MySQL indexing.
ytt
Read More
8 min
Lesson 13 of the SQL Optimization Course: Data Page Merging
Adjusting MERGE_THRESHOLD optimizes data page merging and splitting in MySQL InnoDB, enhancing performance.
ytt
Read More
7 min
Lesson 12 of the SQL Optimization Course: How MySQL Calculates Table Statistics?
Explore MySQL's table statistics calculation, including persistent vs non-persistent options and optimization strategies.
ytt
Read More
4 min
Lesson 11 of the SQL Optimization Course: How to test the performance of compressed tables?
This article discusses monitoring compressed tables in MySQL, highlighting their suitability for read-intensive workloads and providing practical examples of performance impacts.
ytt
Read More
7 min
Lesson 10 of the SQL Optimization Course: How to Use Compressed Tables in MySQL?
Explore MySQL's compressed table techniques for optimizing storage and performance, covering both MyISAM and InnoDB engines with practical examples.
ytt
Read More
7 min
Lesson 9 of the SQL Optimization Course: How to Choose the Right MySQL Tablespace
Explore MySQL's tablespace types with pros and cons. This guide helps you pick the best one to boost performance and ease management.
ytt
Read More
3 min