Hi
List
Thank
you to everyone who took the time to answer, I never realised that there could
be so many solutions :)
Rgds
Denham
-----Original Message-----
From: Denham Eva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
Subject: Long running SQL Problem?Hello List
Is there anyone who can give me a solution to this problem.
It is a sql that runs forever and I eventually have to kill it, both tables are large 500000 + rows.
Is there perhaps a quicker more effecient way of doing this.
SELECT col1,col2
FROM Table_1
WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2);
TIA
Denham Eva
Oracle DBA
This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com