This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
I killed this query after 543 seconds. However, the inner select (select #2) runs in about 7 seconds. It returns 836 records and the RU_METRIC_DET table contains 2597374 records where DETAIL_ID is a primary key.
What I really want to do is a delete from RU_METRIC_DET (i.e. replace select #1 with a delete), which is why I need the outer select.
Can someone help me out with a suggestion? [ October 18, 2008: Message edited by: Marilyn de Queiroz ]
JavaBeginnersFaq "Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt