What is better to use from point of view performance:
I have condition like this:
where ...
and not ( a and b)
and not (c and d)
and not (e and f)
May be better to convert it to the next:
where ...
and ( not a or not b)
and (not c or not d)
and (not e or not f)
?
3
I think you meant AND for second part also.
I just tried to see execution plan. both of them are CONSTANT SCANS.
But, I would suggest to go with option 1, as it is more readable.
2