RE: What impacts index build times on partitioned tables?

2002-02-08 Thread Arun Chakrapani
for this database are running, and the nightly data loads have already finished. Thanks, Cherie àãø éçéàì co.il> cc: Sent by: Subject: RE: What impact

RE: What impacts index build times on partitioned tables?

2002-02-08 Thread Mohammad Rafiq
Rafiq" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: What impacts index build times on partitioned tables? Sent by: [EMAIL PROTECTED] om

RE: What impacts index build times on partitioned tables?

2002-02-08 Thread Cherie_Machler
ammad Rafiq" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: What impacts index build times on pa

RE: What impacts index build times on partitioned tables?

2002-02-07 Thread Mohammad Rafiq
D] [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 07, 2002 5:55 PM > To: Multiple recipients of list ORACLE-L > Subject: What impacts index build times on partitioned tables? > > > We drop and recreate many indexes on our large partitioned fact table

RE: What impacts index build times on partitioned tables?

2002-02-07 Thread אדר יחיאל
] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 07, 2002 6:56 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: What impacts index build times on partitioned tables? > > > Yechiel, > > There is no ot

RE: What impacts index build times on partitioned tables?

2002-02-07 Thread Cherie_Machler
cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTEC

RE: What impacts index build times on partitioned tables?

2002-02-07 Thread אדר יחיאל
] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 07, 2002 5:55 PM > To: Multiple recipients of list ORACLE-L > Subject: What impacts index build times on partitioned tables? > > > We drop and recreate many indexes on ou

What impacts index build times on partitioned tables?

2002-02-07 Thread Cherie_Machler
We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time