On Thu, Sep 1, 2011 at 12:45 AM, Shane Hathaway sh...@hathawaymix.org wrote:
On 08/31/2011 05:11 PM, Darryl Dixon - Winterhouse Consulting wrote:
Just had a quick query from my friendly local DBA; he wanted to know why
--clear was using DELETE rather than TRUNCATE; his comments were along the
Just had a quick query from my friendly local DBA; he wanted to know why
--clear was using DELETE rather than TRUNCATE; his comments were along the
lines of:
* TRUNCATE creates no UNDO
* TRUNCATE cleans out the indexes nicer
Is there any real downside or gotcha I should be aware of to