Query Performance Tuning & Query Rewriting (English) with Amr Elhelw - Tech Vault

Slides: https://github.com/aelhelw/techvault/... Arabic version of this video:    • Query Performance Tuning & Query Rewriting...   ▬ Related Videos ▬▬▬▬▬▬▬▬▬▬ Database Design:    • Overview on Database Design (English) with...   Normalization:    • Database Normalization - 1NF, 2NF, 3NF, 4N...   Database Indexes (part 1):    • Database Indexes - B and B+ Trees (English...   Partitioning:    • Data Partitioning (English) with Amr Elhel...   Query Optimizer:    • SQL Query Optimizer (English) with Amr Elh...   EXPLAIN:    • Understanding EXPLAIN in PostgreSQL (Engli...   Join Types:    • SQL Join Types - Inner, Outer, Semi-join, ...   Materialized Views:    • Materialized Views (English) with Amr Elhe...   ▬ Contents ▬▬▬▬▬▬▬▬▬▬▬▬ 00:00 Intro 00:52 Why we need performance tuning? 02:28 Factors impacting query performance 05:57 Query optimization & Execution plans 12:06 Functions on index keys 16:13 Wildcard search 18:54 UNION vs UNION ALL 22:42 Existence checks 27:41 Subquery or join? 32:08 Keep in mind... 36:44 Summary