Recommendation for row count of a VL Partitioned Table
We have a partitioned table that at last count had 6,683,071,020
What is the best way in Oracle 9i to get a count of the total number of rows in this table and not impact performance too severerly? We are planning to upgrade to 10g but we are not there yet.
you want accurate? then do a count, then analyze the table with a small estimate_percent and check out num_rows in user_tables
On a weekly basis,
I have been doing a SELECT COUNT(ROWID) FROM REALLY_BIG_TABLE;
I'm concerned however. I'm afraid of what impact I may be having on the database performance in doing that. It takes a long time for a 6 billion row count to return.
Is that the best way of getting accurate stats? Doing a count?
I am new on the project at and plan to implement
I have not implemented that yet, Is that the best approach?
How about add a parallel clause?
Can you point me to a syntax reference to do that?
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.
Click Here to Expand Forum to Full Width