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.
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
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.
One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.
COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.