SQL Query Optimizer (Arabic - عربي) with Amr Elhelw - Tech Vault

Slides: https://github.com/aelhelw/techvault/blob/main/Relational_Database_Internals/TechVault_SQL_Query_Optimizer.pdf

English version of this video: https://youtu.be/LznTWam9qhs

▬ Related Videos ▬▬▬▬▬▬▬▬▬▬
SQL Query Life Cycle: https://youtu.be/SEKF4u6Ovyw
Relational Algebra: https://youtu.be/OuFS0tcQXh8

▬ Other Resources ▬▬▬▬▬▬▬▬
PostgreSQL Transformation Rules: https://www.postgresql.org/message-id/attachment/32513/EquivalenceRules.pdf

▬ Contents ▬▬▬▬▬▬▬▬▬▬▬
00:00 Intro
02:01 Why do we need the optimizer?
09:30 Plan Enumeration
18:16 Rule-based optimization
27:49 Cost-based optimization
36:44 Bottom-up approach
44:58 Top-down approach
47:42 Summary

Видео SQL Query Optimizer (Arabic - عربي) with Amr Elhelw - Tech Vault канала Tech Vault