Regarding performance tunnig
-
WHich is more faster to compare values <> or != for performance tunning thanks in advance
It makes no difference, both are the same.
Its the man, not the machine - Chuck Yeager If at first you don't succeed... get a better publicist If the final destination is death, then we should enjoy every second of the journey.
-
WHich is more faster to compare values <> or != for performance tunning thanks in advance
As said, from performance point of view, they are the same. However, since you didn't mention what database you're using, from syntax point of view there may be differences since not all of the databases understand both syntaxes.
The need to optimize rises from a bad design.My articles[^]
-
As said, from performance point of view, they are the same. However, since you didn't mention what database you're using, from syntax point of view there may be differences since not all of the databases understand both syntaxes.
The need to optimize rises from a bad design.My articles[^]
-
SQL Server understands both the operators...no issue at all