How To Read SQL Server Execution Plans

How To Read SQL Server Execution Plans

Bert Wagner

4 года назад

39,996 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@gykg3202
@gykg3202 - 12.10.2023 05:03

Are you Austrian?

Ответить
@tomservo75
@tomservo75 - 21.07.2023 05:35

I"m glad you made this but I would have liked to see more of a deep dive into what to do with the costs including where to put indexes. For example, I have in my plan a Hash Match (Right Outer Join) at 23% cost. I know you mentioned earlier these are causes for concern, but what do I DO (if anything) about it? Nice video overall though.

Ответить
@AbbasKhan-ud6mr
@AbbasKhan-ud6mr - 23.06.2023 17:02

great video, thanks

Ответить
@nitro_1986
@nitro_1986 - 07.04.2023 05:32

Great tutorial- you have a subscriber! This will be my go to channel for SQL related topics.

Ответить
@souravbanerjee1692
@souravbanerjee1692 - 14.07.2022 06:55

Hi Bert, Can you make a series on Oracle PL/SQL execution plan as well? Or how similar / different it is from SQL server ? Many Thanks!

Ответить
@wonderfulworldwelive
@wonderfulworldwelive - 05.04.2022 15:08

bla bla bla

Ответить
@menasheaharonian9183
@menasheaharonian9183 - 28.10.2021 23:05

Basic things, but I didn't know some of them. Appreciate it.
Will be happy to see some videos of hands-on optimization for complex queries.
Thank you 🙏

Ответить
@somayamostafa7473
@somayamostafa7473 - 25.09.2020 02:15

Please rename the video number 3

Ответить
@gianpanacioni4937
@gianpanacioni4937 - 23.03.2020 20:25

Great videos! Help me a lot

Ответить
@MrPierrot69
@MrPierrot69 - 20.08.2019 13:18

Thanks Bert. On percentage cost, well in the end it is always 100%! May be the focus has to be on 'high' percentage for 'small' data volume (small arrows), as it potentially means lot of cost for small output ? (because of non-SARG item for example)

Ответить
@ReuelRamos
@ReuelRamos - 14.08.2019 06:10

Great content man 👍🏻
I like that you cut to the chase on your topics.

Ответить
@akensturgeon
@akensturgeon - 06.08.2019 21:13

Thanks Bert, appreciate you're efforts to teach others.

Ответить
@zanonilabuschagne7628
@zanonilabuschagne7628 - 06.08.2019 18:09

Damn bro, you can't tell everyone about "missing index details" - how will us consultants survive :P

Just kidding, once had an incident with a DBA who literally just used that as a basis for his version of performance tuning... Everytime a report was slow, he'd check the exec plan just to see if it needed an index, and VERBATIM just apply it... The fact that there was a plethora of implicit conversions (some issues with his keys), and a slow HDD in the server obviously had nothing to do with performance.

Great vid as always!!

Ответить
@giriteja258
@giriteja258 - 06.08.2019 15:21

Hello, can you make video of ms SQL database exam and practicing for exam in simply method using website are any application

Ответить