Not Equals performance

Question

Is there a difference in performance between != and <>?

Bonus: why do people get upset when I use != instead of <>? I am of course speculating that all programmers get upset about this, however I have worked for two companies now that "require" the use of <>

@GuilhermeSehn can you convert your response to an answer please. — aaronmallen, Nov 03 '13 at 22:03

score 2 · Accepted Answer · edited Jun 20 '20 at 09:12

2

Short answer: no, there's no difference in performance.

As for the bonus question, I imagine people get upset because != is not defined in the SQL 92 standard and is therefore less likely to be portable.

Edit

The SQL 92 standard can be found here and defines the not equals operator as follows:

<not equals operator> ::= <>

edited Jun 20 '20 at 09:12

Community

1
1

answered Nov 03 '13 at 21:49

Eiríkur Fannar Torfason

1,010
7
15

Thank you for your answer to the bonus. Can you sight sources for your answer to the question? – aaronmallen Nov 03 '13 at 21:55

score 1 · Answer 2 · edited May 23 '17 at 12:03

1

They do not have performance differences, it's certainly for matters of standards/consistence. Take a look at this question: Should I use != or <> for not equal in TSQL?

edited May 23 '17 at 12:03

Community

1
1

answered Nov 03 '13 at 22:04

Guilherme Sehn

6,727
18
35

Not Equals performance

2 Answers2

Edit