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!

Select count from partitioned and subpartitioned table.

751548Feb 4 2010 — edited Feb 5 2010
I need a number of rows in myTable - huge partitioned and subpartitioned table.

I created simple pl/sql blok in loop to get a count for each subpartition incrementing total by this count.
I noticed it takes twice time less than getting count from whole table (select count(1) from myTable).

Why is that?

Thanks,

Michael
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2010
Added on Feb 4 2010
3 comments
13,642 views