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

Report message to a moderator

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: 621
Registered: July 2006
Senior Member
IMHO both methods are valid.
Sometimes EXISTS performs better, sometimes IN is preferred.

Report message to a moderator

Previous Topic: WHERE CLAUSE TUNING
Next Topic: SQL Tuning - Distinct Vs Group by
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 10:39:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.