#sql
SQL PARTITION BY Demystified: The Hidden Mechanics of Window Frames
Understand how PARTITION BY truly works in SQL and unpack the logic hidden behind OVER (PARTITION BY ... ORDER BY ...).
Database Isolation Levels: Why Phantom Read Doesn't Happen in MySQL
A deep dive into database isolation levels and MySQL Gap Lock.
How To determine the order of indexes when using Composite Key
Why the column order of a composite key matters, and how to order it by analyzing the WHERE clause.