• I answered it correctly because I knew what the author was talking about, but for myself I will stick with COUNT(*). (It runs in under 2 seconds on our 70 GB table, so speed isn't that big of an issue.)

    Also, most code completion tools won't help you with the schema and table name when writing the alternate count queries.