Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance Difference Between != and <>?
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 22 2006 - 15:33:07 CDT
![]() |
![]() |