Комментарии:
Are you Austrian?
Ответить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.
Ответитьgreat video, thanks
ОтветитьGreat tutorial- you have a subscriber! This will be my go to channel for SQL related topics.
Ответить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!
Ответитьbla bla bla
Ответить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 🙏
Please rename the video number 3
ОтветитьGreat videos! Help me a lot
Ответить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)
ОтветитьGreat content man 👍🏻
I like that you cut to the chase on your topics.
Thanks Bert, appreciate you're efforts to teach others.
Ответить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!!
Hello, can you make video of ms SQL database exam and practicing for exam in simply method using website are any application
Ответить