Home » RDBMS Server » Performance Tuning » NOt EXISTS & NOT IN ???
NOt EXISTS & NOT IN ??? [message #220163] Mon, 19 February 2007 05:06 Go to next message
yogeshse
Messages: 11
Registered: December 2005
Location: Chennai
Junior Member
Hi,
If I'm not wrong, I know it's better to use NOT EXISTS where it's possible instead of NOT IN clause. Can you give possible reasons supporting this ???

Thx,
Yogesh
Re: NOt EXISTS & NOT IN ??? [message #220180 is a reply to message #220163] Mon, 19 February 2007 06:09 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
IMHO both methods are valid.
Sometimes EXISTS performs better, sometimes IN is preferred.
Previous Topic: WHERE CLAUSE TUNING
Next Topic: SQL Tuning - Distinct Vs Group by
Goto Forum:
  


Current Time: Fri Dec 09 23:36:40 CST 2016

Total time taken to generate the page: 0.08449 seconds