when running a delete query to a table that has many foreign keys I get the following
I noticed that I have both
CXCONSUMER wait types at the same time during of the execution of my query.
the question is:
what is the relation between these 2 wait types (if any)?