hi everyone.

I have three related tables and the Foreign Key contraints on them is ON DELETE CASCADE

The DELETE operation takes a long time (which is unacceptable).

Plz advise me on how to optimise this operation for performance.
Thanks.