circumstances
though, I think rewriting it is the way to go.
Thanks again,
Bill
Quoting [EMAIL PROTECTED]:
Bill Duffy <[EMAIL PROTECTED]> wrote on 08/31/2005 11:32:02 AM:
When I run a query like this
DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM
test_x_RM_4508_48875
When I run a query like this
DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM
test_x_RM_4508_48875 )
it never completes.
test_x_RM_4508_48875 contains 180139 rows. test_P_Cookie contains 22,957,702
rows. There does not appear to be any iowait problem and CPU is about 50 % in
us