Re: Some questions on truncating a partition in Oracle

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 22 Jul 2003 02:00:59 -0700
Message-ID: <1a75df45.0307220100.4d737cc1@posting.google.com>

johnny.yeung_at_unforgettable.com (Johnny Yeung) wrote

> 1. Truncate - Concept
> Here, I truncate a partition. It takes around 10 seconds. Is it
> fast or slow? Is it tunable?

Why be even concerned about tuning the db for doing a truncate fast? You're not in the habit of issuing TRUNCATE commands like they are OLTP sql, are you?

Personally I think attempting to tune DDLs a waste of time than can be better spend tuning DML and other db aspects.

Unless you consider the slow truncate/DDL to highlight a potential db problem that will bite DMLs in the butt.

--
Billy

Received on Tue Jul 22 2003 - 04:00:59 CDT