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@xxxxxxxxx> 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
