All-



I need help on creating a global index, I have a (newly created) partitioned
table that is 4.7G it was converted from a non-partitioned table, we ran dml
(inserts/updates) that were pretty quick now it's taking over 30 mins to
complete not acceptable. I have made the change in our staging env first
before rolling to production. Have over 21Million records currently the
index is like so:



CREATE UNIQUE INDEX PRODUSER.HOSTTRIPS_PK ON PRODUSER.TMI_HOSTTRIPS

(CUST, INDEXKEY)

NOLOGGING

TABLESPACE TMI_HOSTTRIPS_PART_IDX

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

INITIAL 10M

NEXT 10M

MINEXTENTS 1

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 5

FREELIST GROUPS 1

BUFFER_POOL DEFAULT

)

NOPARALLEL;



We have 64 unique CUST values and over 16Million of Indexkey values. Please
help on the syntax for creating a global index.



Thanks in advance,



Demetrius


Oracle LazyDBA home page