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: 125
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: 68734
Registered: March 2007
Location: Saint-Maur, France, https...
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: 125
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: 68734
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
MINUS

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


Current Time: Wed Feb 12 09:04:52 CST 2025