Is BIT field faster than int field in SQL Server?

Question

I have table with some fields that the value will be 1 0. This tables will be extremely large overtime. Is it good to use bit datatype or its better to use different type for performance? Of course all fields should be indexed.

Answer 1

I can't give you any stats on performance, however, you should always use the type that is best representative of your data. If all you want is 1-0 then absolutely you should use the bit field.

The more information you can give your database the more likely it is to get it's "guesses" right.