On Sun, Jul 09, 2006 at 20:35:39 -0700,
nuno <[EMAIL PROTECTED]> wrote:
> hi there.
>
> i'm trying to clear data in a table but somehow it takes way too much
> time than i once expected (i'm using the formal 'delete from xxx' type
> of query.).
>
> this table's got several foreign keys and i su
try truncate. just be aware that truncate is being upgraded in 8.2
for better handling of foreign key isues.
merlin
On 9 Jul 2006 20:35:39 -0700, nuno <[EMAIL PROTECTED]> wrote:
hi there.
i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm usin
Nuno,
It's the foreign keys that point to this table are the problem, not the
foreign keys of the table itself. In other words, the child tables for
which the table you delete from is the parent... do you have indexes on
the foreign keys of the child tables which point to this table ? Those
indexe
hi there.
i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm using the formal 'delete from xxx' type
of query.).
this table's got several foreign keys and i suspect that is why it
takes longer than expected.
my question is that
would having index
