Bitmap index creation taking time

Hi Tom ,

The bitmap index creation on a partitioned table taking lot of time.

The table is small 5.5 GB , however the index creation taking 3 hours even with parallel option.

Could you please help to improve.

Database is in 11.2.0.4

CREATE BITMAP INDEX ULTAPOS.tf_ulta_sales_wkend_bi

ON ULTAPOS.tf_ulta_sales (wk_end_dt)

TABLESPACE ULTAPOS_LG_IDX

PARALLEL 8

LOCAL

Below is the plan :

Plan

CREATE INDEX STATEMENT ALL_ROWSCost: 2,779 Bytes: 509,049,256 Cardinality: 63,631,157

8 PX COORDINATOR

7 PX SEND QC (RANDOM) PARALLEL_TO_SERIAL SYS.:TQ10000 :Q1000Bytes: 509,049,256 Cardinality: 63,631,157

6 PX PARTITION RANGE ALL PARALLEL_COMBINED_WITH_CHILD :Q1000Bytes: 509,049,256 Cardinality: 63,631,157 Partition #: 3 Partitions accessed #1 – #18

5 INDEX BUILD NON UNIQUE (LOCAL) PARALLEL_COMBINED_WITH_PARENT ULTAPOS.TF_ULTA_SALES_WKEND_BI :Q1000Partition #: 3 Partitions accessed #1 – #18

4 BITMAP COMPACTION PARALLEL_COMBINED_WITH_CHILD :Q1000

3 SORT CREATE INDEX PARALLEL_COMBINED_WITH_PARENT :Q1000Bytes: 509,049,256 Cardinality: 63,631,157

2 BITMAP CONSTRUCTION PARALLEL_COMBINED_WITH_CHILD :Q1000

1 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT ULTAPOS.TF_ULTA_SALES :Q1000Cost: 46 Bytes: 509,049,256 Cardinality: 63,631,157 Partition #: 3 Partitions accessed #1 – #18


Thanks,

Sukanta

Related:

Leave a Reply