Counting all the rows

• A

  The count is stored but must be locked before reading

• B

  COUNT(*) is slower than COUNT(1) in this case and really ought to be rewritten

• C

  The table needs an index on its primary key

• D

  The count is not stored, so every row or index entry must be visited