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!

Alternative for select count('x') or count(*)

582246Sep 10 2007 — edited Sep 11 2007

Hi Gurus,

I need to use select count(*) multiple times in a SP before and after deletion of rows from multiple tables. As this is an expensive method, do we have some alternative for Count(*), like selecting something from a system table or view instead?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2007

Added on Sep 10 2007

10 comments

1,117 views