Shawn Invento
Reputation: 13
Performance of sum(1) vs count(1) for counting rows
Is there any difference performance-wise betweenselect sum(1) from Products and select count(1) from Products?
Upvotes: 1
Views: 1655
Answers (1)
ViKiNG
Reputation: 1334
Both took same time on a very large table and when ran them together....came out with each having 50% cost:
Upvotes: 1
Related Questions
- Count(*) vs Count(1) - SQL Server
- Count(*) vs Count(id) speed
- COUNT vs SELECT in SQL
- SQL Server: Performance of count() with where clause
- Efficient use of SQL GROUP BY, SUM, COUNT
- select count(1) vs select rowcnt from sysindexes performance and use?
- Which is faster: Sum(Case When) Or Group By/Count(*)?
- Conditional counting: Performance differences in using SUM() vs COUNT()?
- SQL: using count() vs. keeping a separate field
- select count(*) vs keep a counter