Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> truncate partition

truncate partition

From: Oradba_Linux <techiey2k3_at_comcast.net>
Date: Thu, 12 May 2005 19:52:20 -0400
Message-ID: <IfydnfXW4OZ6dh7fRVn-qA@comcast.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US