MS SQL Server Clients - Creating an index on a BIT column

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Creating an index on a BIT column

Anonymous

2005-12-20, 11:24 am

I had an issue with indexing a BIT column in SQL Server 2000. Every book and
newsgroup I read said that you cannot do this. But you actually can!

Refer to this website:

http://www.aspfaq.com/show.asp?id=2530

Andrew J. Kelly

2005-12-20, 11:24 am

Is there a question here? You certainly can create an index on a Bit column
but the question is do you really want to? Most of the time the selectivity
is too low to be of use for an index. But under certain conditions it makes
sense.

--
Andrew J. Kelly SQL MVP

"Anonymous" < Anonymous@discussion
s.microsoft.com> wrote in message
news:3339C46D-605A-4522-852D- E67DDA36B8DF@microso
ft.com...
>I had an issue with indexing a BIT column in SQL Server 2000. Every book
>and
> newsgroup I read said that you cannot do this. But you actually can!
>
> Refer to this website:
>
> http://www.aspfaq.com/show.asp?id=2530
>

Sponsored Links