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

Описание: Slides: https://github.com/aelhelw/techvault/...

English version of this video:    • SQL Query Optimizer (English) with Amr Elh...  

▬ Related Videos ▬▬▬▬▬▬▬▬▬▬
SQL Query Life Cycle:    • SQL Query Life Cycle (Arabic - عربي) with ...  
Relational Algebra:    • Relational Algebra - Deep Dive (Arabic - ع...  

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

▬ 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