Below you will find pages that utilize the taxonomy term “Commands”
Posts
read more
Count and Its Many Guises
Context
So why am I blogging about the count command today? Its mainly because I keep on seeing this come up on my feed. Normally the posts are under the guise of look at this interview question or junior DBAs should know this.
Which is great but the articles rarely show why one is better then the other, or even how the query planner looks at the query that you are running. The conclusions of this blog may be the same as the quick articles but hopefully this will provide a bit more information as to the WHY. This post relates to the POSTGRES dbengine.