Index a bit field

Index a bit field

Post by Mark DeWaa » Thu, 03 Jul 2003 06:59:06


Is there any way to index a bit field in a composite index?
 
 
 

Index a bit field

Post by Gert-Jan S » Thu, 03 Jul 2003 07:41:20

Yes, that is, if you are using SQL-Server 2000. Older versions do not
support indexing bit columns.

Gert-Jan

 
 
 

Index a bit field

Post by Mark DeWaa » Fri, 04 Jul 2003 22:43:41

I was able to successfully create an index on a bit field using query
analyzer.

What confused me was that bit fields don't show up in Enterprise manager's
drop down field for indexes. Also many websites still say that bit fields
cannot be indexed

Thank you for your response.