Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: truncate partition
Oradba_Linux wrote:
> with update global indexes.
> We did this on 2 partitions of different tables today and timings were
> very different.One was 10 minutes and other was 100 minutes. Number of
> rows are similar but the table that took longer had one more index.
> But that index was on a nullable column and it was very small.
> I know i am little ambiguous here but just looking for some guesses.
>
> Thanks
TK_PROF.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu May 12 2005 - 19:10:39 CDT