Index on a Bit Column

Question

Index on a Bit Column

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

Since there are only two possible values to index I do not think the indexes would do you much good. Unless there is a very small amount of the values that have one of the two values.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Graeme100 SSCrazy Eights Points: 8054 More actions · Answer 2

Graeme100

SSCrazy Eights

Points: 8054

July 1, 2005 at 3:25 am

#570263

That was also my understanding !!

Thanks for that