Arpit Bhayani
Projects
Blogs
Notes
Videos
Papershelf
Bookshelf
Courses
Talks
Home
Topics
Query Optimization
#query-optimization
(4)
4 videos
All
4
Databases
3
Systems Internals
1
2024
(2)
May 04
VIDEO
How PostgreSQL Generates All Query Execution Plans
Systems Internals
#postgresql
#query-optimization
#query-planner
Apr 26
VIDEO
Database Join Algorithms: How Nested Loop, Sort-Merge, and Hash Joins Work Internally
Databases
#databases
#systems-internals
#query-optimization
2022
(1)
Jun 06
VIDEO
Post-Mortem: How a Single MySQL Index Broke GitHub
Databases
#mysql
#indexing
#databases
2021
(1)
Apr 10
VIDEO
Generating 5 Million Hierarchical Rows in Under 100 Seconds Using Pure SQL
Databases
#sql
#mysql
#database-performance