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!

SQL%ROWCOUNT vs count(*)

user604558May 21 2008 — edited May 21 2008

Hi,

I need to get the count of huge tables having record count more than 2 billion.

Iam handling this in pl/sql procedure, which approach is the best

1. SQL%ROWCOUNT or
2. select /*+ parallel(src) */
count(1)
into v_t1_src
from table.

Please note we have multiple cpu and the process run in parallel

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2008

Added on May 21 2008

5 comments

1,446 views