I don't know the specifics, just that it has to do with transactions and isolation. You're not just getting a raw count of the records in the table, you're getting the count for your particular view of the table, from when your transaction started. A lot more bookkeeping.