Skip to Main Content
Forums

Oracle Database Discussions

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!

Bitmap Index NUM_ROWS Count Difference On Partitioned and Non-Partitioned Table

RamarajuOct 1 2018 — edited Oct 1 2018

Hi All,

I have previously posted some queries on Partition Table. I have completed the partition on table. After that I have observed there is a difference on a bitmap index num_rows count before and after partition.

SQL> select owner,index_name,partitioned,table_owner,table_name, num_rows,partitioned,temporary,last_analyzed,status from all_indexes

where index_name like 'OE_ORDER_HEADERS_DSS1';

Before Table & Index(OE_ORDER_HEADERS_DSS1) Partition:

pastedImage_2.png

After Table and Index(OE_ORDER_HEADERS_DSS1) Partition:

pastedImage_3.png

Bitmap index should be Local on partitioned table.

Thanks,

Ramaraju
This post has been answered by Jonathan Lewis on Oct 1 2018
Jump to Answer
Comments
Post Details
Added on Oct 1 2018
#general-database-discussions
5 comments
409 views