'create bitmap index' on a large partitioned table very slow after upgrade to 9.2.0.4

Home -> Community -> Usenet -> c.d.o.server -> 'create bitmap index' on a large partitioned table very slow after upgrade to 9.2.0.4

From: Shehnaz N. <Shehnaz_Nurmohamed_at_cpr.ca>
Date: 26 Nov 2004 10:33:38 -0800
Message-ID: <1adc56d1.0411261033.39529375@posting.google.com>

An index that used to take a half hour to build on HPUX 11 with 8.1.7.0 is now taking over two hours on AIX 5.2 with 9.2.0.4. This is my index build statement:

create bitmap index EQPMV.FACT_TRAFFIC_SEGMENT_IX23 on EQPMV.FACT_TRAFFIC_SEGMENT
(SHIPMENT_ID)
LOCAL
tablespace FACT_PART_10M_INDX01
NOLOGGING PARALLEL 4 The table is partitioned and has over 170 million rows. When I look at what is executing, I notice the following difference:

AIX Server with 9.2.0.4: /*+ NO_EXPAND FULL(A1) BITMAP(16360 127) */ HP UX Server with 8.1.7.0 /*+ NO_EXPAND FULL(A1) BITMAP */

Does anyone know what these numbers mean (16360 127)? The numbers stay consistent regardless of how many times I try to rebuild this or any other bitmap index on this large table.
Any idea why it takes so long to build the index?

Thanks. Received on Fri Nov 26 2004 - 12:33:38 CST