Section
6 pages
Database Fundamentals
Posts written for people learning relational databases: transactions, MVCC, isolation levels, indexes and query plans, each explained from a real PostgreSQL or MySQL run.
Clustered vs Non Clustered Index: The Table Is the Index in Mysql
0
Database Deadlocks, Part 1: The Patterns
0
Hash Join vs Merge Join vs Nested Loop: When Each One Wins
0
How to Read Explain Analyze: Mysql
0
How to Read Explain Analyze: Postgresql
0
Random Uuids as Primary Keys: The B Tree Penalty
0