Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 'create bitmap index' on a large partitioned table very slow after upgrade to 9.2.0.4
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 */
Thanks. Received on Fri Nov 26 2004 - 12:33:38 CST