SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference in num_rows and COUNT function.

user9077483Dec 7 2012 — edited Dec 7 2012

Hi Experts,

SELECT COUNT(*) FROM APP.Big_table; Number of record--222653402

This is a big table to get the it's taking 8 minutes time,
so that I tried the following SQL to get the count quickly.

SELECT num_rows FROM all_tables WHERE table_NAME='BIG_TABLE'
and owner='APP'; --Number of records 237213998

But I got the different count for the two SQLs.
Why there is a difference in the count.
Which one is correct.
Please help me.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2013

Added on Dec 7 2012

3 comments

2,022 views