Home » SQL & PL/SQL » SQL & PL/SQL » can we use an outer joing instead of "NOT IN" and how? any example?
can we use an outer joing instead of "NOT IN" and how? any example? [message #338920] Wed, 06 August 2008 04:49 Go to next message
kashifchughtai
Messages: 113
Registered: October 2007
Senior Member
No Message Body
Re: can we use an outer joing instead of "NOT IN" and how? any example? [message #338922 is a reply to message #338920] Wed, 06 August 2008 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your opinion? Why?

Regards
Michel
Re: can we use an outer joing instead of "NOT IN" and how? any example? [message #338934 is a reply to message #338922] Wed, 06 August 2008 05:01 Go to previous messageGo to next message
kashifchughtai
Messages: 113
Registered: October 2007
Senior Member
Actualy it takes lot of time when we use "not in" statment. Actualy we have two tables with similar structure in differnt scehmas ( like LIVETABLE, STAGINGTABLE) Live table have 20 million records. I need only those records which are not present in STAGINGTABLE but present in LIVE ONE.
Re: can we use an outer joing instead of "NOT IN" and how? any example? [message #338941 is a reply to message #338934] Wed, 06 August 2008 05:11 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
MINUS

Regards
Michel
Previous Topic: Exception handling
Next Topic: help in SQL Sorting
Goto Forum:
  


Current Time: Sun Dec 04 04:21:02 CST 2016

Total time taken to generate the page: 0.11207 seconds