• I have tried on activity monitor as it shows wait type as IO_COMPLETION.

    I have tried creating indexes on a table which i join while updating

    but query still does not completing execution...

    🙁