Re: slow delete

On Tue, Aug 15, 2023 at 4:23 PM Les <nagylzs@gmail.com> wrote:

{
>
> "Trigger Name": "RI_ConstraintTrigger_a_75463",
>
> "Constraint Name": "fk_pfq_src_product_file",
>
> "Relation": "product_file",
>
> "Time": 11179.429,
>
> "Calls": 90
>
> },
>
...


> The one with fk_pfft_product looks like this, it has about 5000 records in
> it:
>

That constraint took essentially no time.  You need to look into the one
that took all of the time,
which is fk_pfq_src_product_file.

Cheers,

Jeff

>