-
Recommendation for row count of a VL Partitioned Table
We have a partitioned table that at last count had 6,683,071,020
Rows.
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.
Thanks.
-
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
DBMS_STATS.GATHER_SCHEMA_STATS(VAR_CSCHEMA_NAME, DBMS_STATS.AUTO_SAMPLE_SIZE);
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?
Thanks.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|