Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> truncate partition
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 Received on Thu May 12 2005 - 18:52:20 CDT