Doubt in Perfomance in SQL

0

A question that has arisen now, and which I always see in one form or another in procedure SQL, is as follows: NOT TABELA.CAMPO IS NULL or TABELA.CAMPO IS NOT NULL . What's the difference in practice in performance issues, run time, from one to the other? Would the perfomance be affected, depending on the number of records in the table and / or the existence of the index in the field?

    
asked by anonymous 26.02.2018 / 19:56

1 answer

0

There is no measurable performance difference. Both forms are compiled and optimized for the same internal representation by any modern DBMS, then have the same performance.

    
26.02.2018 / 20:04