[dba-SQLServer] Pointless Indexes?

Arthur Fuller fuller.artful at gmail.com
Mon Aug 11 15:01:02 CDT 2008

You're precisely correct, that is what that column (called IsActive) does,
but some of the reading I've done suggests that a) you can't index a bit
column even in a compound index -- although it is listed in the indexed
columns so this part is especially confusing; and b) that given an
approximately 50-50 ratio of Yes and No in said column, even if indexed the
optimizer will prefer a table scan. I'm just beginning to learn about
Execution Plan etc. so I don't know whether I'm misreading the articles or
the evidence or both.


On Mon, Aug 11, 2008 at 4:35 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> Hi Arthur:
> I would not know why your particular client would index a bit column but I
> use that a lot of times as a super fast group index for inactive and active
> records in any DB.... as you know account transactions can never be
> deleted...
> Jim

More information about the dba-SQLServer mailing list