Skip to Main Content
Forums

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!

Poor Performance on SELECT COUNT(*) from empty table after INSERT & DELETE

563997Feb 26 2007 — edited Mar 3 2007
Hi @ all,

after inserting a large no. of rows (> 100.000.000) into a table and deleting them at the same time, the table is EMPTY.

However a SELECT COUNT(*) FROM TABLE takes up to 3 minutes, only after truncating the table in question the same query takes only 0.02 seconds!

Is there any possibility to establish a defragmentation like truncate whilst accessing the table?

Thx for your answers in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2007
Added on Feb 26 2007
9 comments
1,582 views