WILL>>Have you tried gathering statistics? I found that the analyze
command doesn't work too well on partitioned tables. Try (all on one line):

execute DBMS_STATS.GATHER_TABLE_STATS ('SCHEMA_NAME', 'TABLE_BAME'
,NULL,5,false,'FOR ALL COLUMNS SIZE 1',8,'default',TRUE,NULL,NULL,NULL);



Harper Demetrius wrote:

>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
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>


Oracle LazyDBA home page