If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

If you have an index on the table, either a btree index on a nonnull comment or a bitmap index on any, then that can be used to get a row count.

By the way count(rowid) means nothing other then count(*) ... Same thing.

I'm disturbed that you are new on the project and planning to implement a statistics gathering job without fully understanding it, or presumably being aware of what gathering method has been used before.