SQL SERVER: Why We Should Avoid COUNT (*)

added by lionofdezert
1/12/2011 3:12:46 AM

0 Kicks, 60 Views

COUNT(*) is commonly used to get total row count of a table/query. COUNT(*) is bit resource hungry method and should be replaced with some performance friendly methods.


0 comments