Re: Avoid the fragmentation in 9.2

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 2 Mar 2005 21:18:56 -0000
Message-ID: <42262dbe$0$2762$cc9e4d1f@news-text.dial.pipex.com>

<joel-garry_at_home.com> wrote in message
news:1109726216.392237.312980_at_z14g2000cwz.googlegroups.com...
>>> Another DBA told me there is restriction of TRUNCATE table for
> million
>>> records even I use the drop storage option. IS that true?
>
>
>>In a word, No. Get them to show you. If they can't show you set up a
> test
>>with say 15m records (ten times your expected load). TRUNCATE will
> pass the
>>test.
>
>
> Shouldn't the word be maybe? We haven't determined yet if this is an
> "upgraded" DMT with possibly severe extent issues or other weirdness.

Hi Joel,

No, it *will* pass the test, admittedly it may take a few days :) but TRUNCATE will work *at least as well* as delete.

Niall Received on Wed Mar 02 2005 - 15:18:56 CST