RE: Performance Difference Between != and <>?

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <srcdco@xxxxxxx>
Date: Fri, 22 Sep 2006 22:33:07 +0200

Scott

> If you use !=, it returns sub-second.  If you use <>, it takes 7
> seconds to return.  Both return the right answer.

Just out of curiosity... Does the query optimizer generate a different
execution plan for the two queries?


Regards,
Chris
--
//www.freelists.org/webpage/oracle-l

Other related posts:

» Performance Difference Between != and <>?
» Re: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» Re: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» RE: Performance Difference Between != and <>?
» Re: Performance Difference Between != and <>?