Query Performance Tuning & Query Rewriting (Arabic - عربي) with Amr Elhelw - Tech Vault

Slides: https://github.com/aelhelw/techvault/blob/main/Building_With_Databases/TechVault_Query_Performance_Tuning.pdf English version of this video: https://youtu.be/z5csGAXNPBs ▬ Related Videos ▬▬▬▬▬▬▬▬▬▬ Database Design: https://youtu.be/gZ5iYMkrcfQ Normalization: https://youtu.be/1HEHa_EJa0k Database Indexes (part 1): https://youtu.be/1ZhBULsbZGw Partitioning: https://youtu.be/XnCnIWMxEhA Query Optimizer: https://youtu.be/iAxFGRbAh8s EXPLAIN: https://youtu.be/12puiczFlz8 Join Types: https://youtu.be/4RmzfVUVxYI Materialized Views: https://youtu.be/qcJiNoQxHQg ▬ Contents ▬▬▬▬▬▬▬▬▬▬▬▬ 00:00 Intro 00:53 Why we need performance tuning? 02:46 Factors impacting query performance 05:51 Query optimization & Execution plans 13:06 Functions on index keys 16:06 Wildcard search 18:51 UNION vs UNION ALL 22:58 Existence checks 27:51 Subquery or join? 32:29 Keep in mind... 36:27 Summary