Pages

Monday, June 22, 2009

!= or <> in oracle

Both the "!=" and "<>" operators means not equal in in oracle. But in oracle 10.2 they have different execution plan. It has a huge speed variation in some cases. Here you will get the query which will show you the difference in these two. Oracle version is an important issue here. 


No comments:

Post a Comment