After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.
After reading it, lots of people asked me if I can make a video on this topic. Of course, here we go, Read Only Tables – Is it Possible?
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.
Based on my recent two videos, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.
COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.