Re: ASSM bug: slow INSERT after uncomitted DELETE

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 16 Aug 2009 21:03:18 +1000
Message-ID: <h68ool$a0$2_at_news.eternal-september.org>

Jonathan Lewis wrote,on my timestamp of 13/08/2009 7:33 PM:

>> Unfortunately, in the situations where you want to delete everything
>> older than 60 days, truncate is not an option.
>>
>>
>>
>> -- 
>> http://mgogala.freehostia.com

>
>
> It is if you partition by day and use only local indexes ;)
>
> Really, this discussion is only picking up the point that
> we need to know that each feature has some side effects
> that may need special consideration.
>

Exactly! Received on Sun Aug 16 2009 - 06:03:18 CDT