Search
Alon Spiegel
- Nov 26, 2023
- 1 min
Dispelling the Myth: count(*) vs. count(1) Efficiency in Modern Databases
As an experienced DBA, I often encounter the belief that SELECT COUNT(1) is faster than SELECT COUNT(*). While this may have held true...
Alon Spiegel
- Jan 7, 2021
- 2 min
Real world use case for JSON in RDBMS PostgreSQL
How I used JSON in RDBMS. I used PostgreSQL but other databases that support JSON, such as MySQL, can also be used