|
NULL IS NOT NULL in execution plan
NULL IS NOT NULL is means always FALSE. Optimzier will add such filter when it found the logic result of the sub plan tree is FALSE, it will cause to the plan tree will never be executed. When find such filter added by optimizer, it's normally means a logic problem in the SQL.
|
最新文章