I have a table called testtable. In this table have column flag with bit data type.
When I run this query. it very slow.

select * from testtable where flag=0


How can I improve this?


Thanks


Jim