>Sorry for so many questions this morning. I found a "bottleneck" in my app (not super critical but I need to find a way to deal with it).
>
>If I am to add a column that will have two values, False and True, and build an index on this column, would the column type BIT be the best? In terms of including this column in the WHERE clause? Logically, I think, Bit would be the best, 0 and 1. But there could be a case of making this column Char(1) and storing '0' or '1'.
>Which one would give me better performance (speed) in SQL Select?
For logical values, I always use Bit. I have found this to work very well with indexing.