I'm running on update to a table (Table\_A) that has 9.5 million records. I've been running it for 13 hours and it still hasn't finished! Can someone point me in the right direction in terms of how to speed it up? I can use PL/SQL to store the sub-selects into variables if that would make it faster. I'm an Oracle newbie and would appreciate any help.

```
update Table_A
set STATUS='DELETED', DESC='REDACTED', NAME=dbms_random.string('A', 20)
where Table_B_ID in (
    select ID
    from Table_B
    where Table_C_ID in (
        select ID
        from Table_C
        where XYZ_ID!=56
    )
);

```

Table\_A has 9.5 million records  

Table\_B has 430,000 records  

Table\_C has 3050 recoreds