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!

Select count(*) never ever ends

user454080Sep 25 2007 — edited Oct 1 2007

Hi,

I loaded a 22 million row table and added an index (non-unique) in a 10.2 database.

I then ran a 'Select count(*) from ' this table and it never ends. Same result for counts on any column. SQL Developer just hangs and other gui(s) never stop churning. Memory and disk are ok. The Explain Plan shows parallel aggregate steps and a full table scan. I used a no_parallel hint and it just did a full table scan but still ran forever. An index hint didn't help. Re-running stats had no effect either.

Any ideas?

Thanks,

Victor

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2007

Added on Sep 25 2007

8 comments

1,528 views