When to use Count(PK_ID) and when to use system tables?

Question

We can use either count(<column_name>) or system tables to get the number of rows in a table. Then where to use which one?

Thanks Devi

Answer 1

Use the system tables/planer estimates when a (quick) approximate number of rows is acceptable. This requires that the table stats are reasonably accurate.