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!

Count taking long time for few rows

554581Dec 28 2007 — edited Jan 2 2008

Hello,

We have table which is 3 mins to count 116K rows. Is there anyway to tune this other than drop and recreate the table?

This table is daily used to insert/update and delete data. But on average we keep around 75K rows.

Thanks
Manohar

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2008

Added on Dec 28 2007

14 comments

1,835 views