Tag: MySQL Index

2 posts

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

Apr 17, 2025

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

Apr 15, 2025