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