📝 Parottasalna Blog

248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.

1 article tagged #SQL Performance · Clear filters

Learning Notes #74 - Understanding Count(*) and Count(1) for counting rows

When working with SQL, counting rows in a table is a common task. Two widely used methods for this are COUNT(*) and COUNT(1). While both seem similar…

Feb 14, 2025 · 3 min read