which is more efficent not in(' ',' ') or <>" " and <>" "

W

Wayne Anderson

I'm trying to make a query more efficient working with large tables. Which
would be the more efficent use?
not in(' ',' ') or
<>" " and <>" "
or possibly another formula or combination...

Thank you,

Wayne Anderson
 
J

John Spencer

It probably doesn't make any difference. The engine that runs the query
will probably optimize them both the same.
 
Top