Is not in (a,b,c) faster than where != a, b, c When writing a query which is faster?

SELECT * FROM table where column not in (a,b,c);


or:

SELECT * FROM table where column != a AND column != b AND column != c ;
I don't think there will be a noticeable difference. Query optimization has very little to do with the syntax of your query and a lot to do with the RDBMS query optimizer. The optimizer pulls apart your queries and optimizes it as it sees fit.