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 <wegein@gmail.com> 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 suspect that is why it
> takes longer than expected.
>
> my question is that
> would having indexes increase query performance when clearing tables?
> or could anyone suggest me any ways to increase performance of the
> query in such cases?
>
> thanks very much.
>
> regards, nuno
