Day: October 20, 2010

  • 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…