-
Efficient use of COUNT()
The other day I was trying to figure out how many records there were in my DB I found in a website that I needed to use COUNT(*). The example given went something like this: SELECT COUNT(*) FROM ‘table’ and while this worked as advertised, I got a very inconvenient side effect. The query was…