Scribblings of a Microsoft Dynamics GP MVP
Using SQL to retrieve number of records in a table – David
David gives an alternate SQL option for the simple COUNT(*) and explain how it improves the performance as against COUNT(*).
You may have to go thru’ the comments as well; some comments discuss the post further.
VAIDY
Excerpt from:
Using SQL to retrieve number of records in a table – David