On Tue, Aug 15, 2023 at 4:23 PM Les <nagylzs@xxxxxxxxx> 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