Category Archives: Databases

Performance Benefits Of COUNT(*) In SQL

      No Comments on Performance Benefits Of COUNT(*) In SQL

This is something I often come across in code.  Just came across it in our MySLP project today , in fact.

While the performance impact of that statement in itself is negligible, it does add up.  For most database engines that statement incurs additional overhead as it processes logic… Read more »