Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SELECT count(*) - A myth busted

Oct 26 2011 6:28AM by Latheesh NK   

When we use select count(), the query processor will use scan on the index with the smallest number of pages to find the result of select().

Read More..   [27 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Latheesh NK
51 · 4% · 1178
12
 
4
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

2  Comments  

  • I had to go to Paul's link to confirm the typo in this post. I believe you want to refer to COUNT(*), not SELECT(*)

    For COUNT(*), scanning the index makes sense. In fact, it is one of the most accurate methods to get the count of records in a given table. You may be interested to read more about it in my post: Measuring the number of rows in a table – are there any alternatives to COUNT(*)?

    commented on Oct 29 2011 8:25AM
    Nakul Vachhrajani
    4 · 36% · 11622
  • Nakul, great post!!! really enjoyed it. Thats my bad select(*)...I will edit it...

    commented on Oct 31 2011 12:07AM
    Latheesh NK
    51 · 4% · 1178

Your Comment


Sign Up or Login to post a comment.

"SELECT count(*) - A myth busted" rated 5 out of 5 by 12 readers
SELECT count(*) - A myth busted , 5.0 out of 5 based on 12 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]