SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177

SUM(1) vs COUNT(1) Performance Battle - SQL in Sixty Seconds #177 177-SomeOne-main-yt-800x450 Based on my recent two videos COUNT(*) and Index – SQL in Sixty Seconds #175 and COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.

I personally, had great fun building this video. You can watch the video over here.

You can get the script used in this video from here: SQL SERVER – SUM(1) vs COUNT(*) – Performance Observation

Well, that’s it for today. If you liked this video, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

, , , ,
Previous Post
COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176
Next Post
June 2021 Summary for SQL in Sixty Seconds

Related Posts

Leave a Reply

Menu