Vjeko, wrote some very good posts about the bad performance of COUNT function used in Microsoft Dynamics NAV. You can check them out at the end of this post.
COUNT function can be used in NAV to find out how many records with certain filters you have in the database.
Let’s take a simple example and check also what happens at SQL Server queries level when you use COUNT vs when you use a NAV Query: