5 SQL Performance Tuning Tricks with Query Rewrites
Автор: ETL SQL
Загружено: 2020-10-28
Просмотров: 1251
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/
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: