Re: truncate tables in my tablespace
From: gazzag <gareth_at_jamms.org>
Date: Fri, 18 Jan 2008 03:07:25 -0800 (PST)
Message-ID: <21feb5c8-cf61-4281-a693-78b3e3f1b0e4@c23g2000hsa.googlegroups.com>
Date: Fri, 18 Jan 2008 03:07:25 -0800 (PST)
Message-ID: <21feb5c8-cf61-4281-a693-78b3e3f1b0e4@c23g2000hsa.googlegroups.com>
On 18 Jan, 10:53, burrell.j..._at_yahoo.com wrote:
> Thanks you all for the very thorough answers- One question remains
> tho. My intention is the thro all the data away so would delete from
> tablename have the same restriction with constraints as truncate?
> J- Hide quoted text -
>
> - Show quoted text -
Yes, DELETE will also have issues with foreign keys. Plus, TRUNCATE will be faster.
HTH -g Received on Fri Jan 18 2008 - 05:07:25 CST