Home » SQL & PL/SQL » SQL & PL/SQL » Select versus Delete?
Select versus Delete? [message #19870] Mon, 15 April 2002 10:07 Go to next message
Leo
Messages: 14
Registered: March 2000
Junior Member
Query 1:-
select count(*)
from t1
where exists (select c1 from t2 where t1.c1=t2.c1)

This runs in 2 mins.

Query 2:-
delete
from t1
where exists(select c1 from t2 where t1.c1=t2.c1)

This query still running for last 2 hours!!!
Any guesses why?

Report message to a moderator

Re: Select versus Delete? [message #19875 is a reply to message #19870] Mon, 15 April 2002 16:51 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
Delete statement might wait for locking by other session(v$lock). Hope this is helping

Report message to a moderator

Previous Topic: 121 library cache
Next Topic: dll
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 08 08:23:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.