5 SQL Performance Tuning Tricks with Query Rewrites скачать в хорошем качестве

5 SQL Performance Tuning Tricks with Query Rewrites

In this video, I have shared 5 examples of common SQL query and what all options we can try to re-write the query to tune it. The intent of this video is to share different ways in which we can re-write any given SQL query to optimise the performance. Below is the timeline: 00:00 : Introduction 02:25 : Example 1 - functions used in Join columns 11:50 : Example 2 - Applying same filter condition to Joining Columns. 17:23 : Example 3 - Pushing operation to static value in comparison rather than actual column 20:05 : Example 4 - Using Column List rathe than * in SELECT clause 23:20 : Example 5 - Group BY vs TEMP table vs WINDOW function You can create derived table or temp table with business logic and use that in the actual query. In many cases this shall show better performance than original query. Also all the method shared in this video may or may not give better results so you have to try it and pick the best option for that query. Website https://etl-sql.com/