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.
This blog will share details about the free webinar – SQL Performance Monitoring with Wait Statistics Scripts. Let us discuss it today.
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.