Re: Strange performance on DELETE

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 7 Oct 2002 01:25:28 -0700
Message-ID: <bde5777e.0210070025.776e591f@posting.google.com>

"Oraclion" <inferno74_at_caramail.com> wrote in message news:<anmr66$79$1_at_wanadoo.fr>...
> Hi
>
> I've this:
> Delete from FAL_DISPO4 where FAL_COMPOSANT6_ID =10;
>

Is table FAL_DISPO4 parent for some child tables. Is the FK of the child tables to FAL_DISPO4 indexed Is there perhaps a delete cascade?

Switch on sql-tracing, and check the trace file. It should reveal this behaviour.

Kind Regards,

Herman de Boer. Received on Mon Oct 07 2002 - 03:25:28 CDT