Index on bit type column

can we create an index on a column of Bit Data type?
Hi,
Yes, You can create index on a bit data type column.
Thanks
Hari
MCDBA
"Lalit" <anonymous@.discussions.microsoft.com> wrote in message
news:4ada01c42c3f$8acb0820$a401280a@.phx.gbl...
> can we create an index on a column of Bit Data type?
|||... in SQL2K, not in prior versions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:%23%23JvhBELEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Yes, You can create index on a bit data type column.
> Thanks
> Hari
> MCDBA
> "Lalit" <anonymous@.discussions.microsoft.com> wrote in message
> news:4ada01c42c3f$8acb0820$a401280a@.phx.gbl...
>
|||Thanks both of you for the quick reply

>--Original Message--
>... in SQL2K, not in prior versions.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:%
23%23JvhBELEHA.3292@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
message
>
>.
>