Question: Is there a considerable performance improvement when using <> over the != operation in Microsoft SQL Server or Oracle Database ?
Answer: The answer is 'NO'. I had from somewhere heard the same that the <> operator performs better than the != operator. The < > operator for NOT EQUAL to can be preferred as the <> syntax is ANSI compliant unlike the != operator. Chances are when you migrate the same code to a different database, the <> operator is more likely to work without any compilation errors.
So use <> operator instead of != as it is ANSI compliant and will help you reduce probable effort if a database migration happens.
References: Stack Overflow
No comments:
Post a Comment