Hi Gail,

Thanks for you prompt reply, the boolean is alone and there are no other ones. What is your final thought on it.

How about if I have a boolean column where its value is always 0 or 1. Is that a good candidate for NonClustered index? I use it in my where...