Home » RDBMS Server » Server Administration » Re: NOT IN operator - very slow
Re: NOT IN operator - very slow [message #370915] Mon, 06 March 2000 10:58
Halvor Nyberg
Messages: 2
Registered: March 2000
Junior Member
Thanks,
Your suggested query used:
2,47 seconds

Tested with:
http://members.tripod.com/easydoc/dim.htm

I still believe there is a faster way by using outer join and Null in the WHERE part.

Report message to a moderator

Previous Topic: Select only one record from query result?
Next Topic: Thanks for the reply, Frank Naude
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 08 01:36:38 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.