Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Bitmap index in sql server

    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,
    Sam

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    If 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

  3. #3
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    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.

    Quote Originally Posted by kaiowas
    If I'm not mistaken a bitmap index also indexes null values.
    In SQL Server you can also create indexes that allow null values
    Johan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •