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...
> > can we create an index on a column of Bit Data type?
>|||Can we create an index in SQL Server 7.0 on Bit data type
column.
>--Original Message--
>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?
>
>.
>|||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...
>> 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?
>>
>
>.
>|||Hi Lalit,
As Tiber mentioned earlier. No, we cant create an index on bit data type
column in SQL 7 or earlier versions.
Only from sql 2000 we can create index on bit column.
Thanks
Hari
MCDBA
"Lalit" <anonymous@.discussions.microsoft.com> wrote in message
news:4d4e01c42c46$95e0b140$a101280a@.phx.gbl...
> Can we create an index in SQL Server 7.0 on Bit data type
> column.
> >--Original Message--
> >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?
> >
> >
> >.
> >