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

Slides: https://github.com/aelhelw/techvault/blob/main/Building_With_Databases/TechVault_Query_Performance_Tuning.pdf Arabic version of this video: https://youtu.be/RtXQug0DuVo ▬ Related Videos ▬▬▬▬▬▬▬▬▬▬ Database Design: https://youtu.be/5CFphPMgScU Normalization: https://youtu.be/lsojlIT1ah0 Database Indexes (part 1): https://youtu.be/1fETPYKyb70 Partitioning: https://youtu.be/6emnnIL9Grc Query Optimizer: https://youtu.be/LznTWam9qhs EXPLAIN: https://youtu.be/ttGNcRgghlE Join Types: https://youtu.be/_UJzUo0Kh7M Materialized Views: https://youtu.be/8S9p7IO2xz0 ▬ 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