Hi
I was using bitmap index in Oracle and now moving to SQL Server 2000. Is there any "equivalent" of bitmap index in sql server ? Any help / links ?
Thanks,
SamIf I'm not mistaken a bitmap index also indexes null values. As far as I know, sqlserver does not have special indexes (not) considering specific null values. A regular index will work. Lookup Indexes in Books Online (BOL).
In the analyzer (turn on execution plan):
use monkey
go
set nocount on
create table tab1 (myint integer null, myval integer not null)
go
create index idx_tab1_myint on tab1 (myint)
go
insert into tab1 (myint, myval) values (1,1)
insert into tab1 (myint, myval) values (null,2)
go
select myint from tab1
go
drop table tab1
go|||A bitmap index is an index that can be used on columns with little different values in it (eg sexe: values male, female and unknown/null), for example in Oracle. This type of index is not available in SQL Server.
If I'm not mistaken a bitmap index also indexes null values.
In SQL Server you can also create indexes that allow null values
Showing posts with label bitmap. Show all posts
Showing posts with label bitmap. Show all posts
Subscribe to:
Posts (Atom)