Results 1 to 2 of 2

Thread: B-tree index and Bitmap index

  1. #1
    Moderator
    Join Date
    Oct 2005
    Answers
    305

    B-tree index and Bitmap index

    Good morning,

    I'm happy to discuss with you regarding Datawarehousing, recently I have completed the course. I'm looking for real time ppl to help me regarding interview point of view.

    Can anyone plz tell me the difference between B-tree index and bitmap index...

    Why bitmap index is useful in Datawarehousing ?

    Could anyone plz explain with example..

    I'm looking fwd for ur reply..
    thq..

    NOTE : [This question was asked by harikrishna, I am posting it in proper forum]


  2. #2
    Junior Member
    Join Date
    Dec 2008
    Answers
    1

    Re: B-tree index and Bitmap index

    Specify BITMAP to indicate that index is to be created with a bitmap for each distinct key, rather than indexing each row separately. Bitmap indexes store the rowids associated with a key value as a bitmap. Each bit in the bitmap corresponds to a possible rowid. If the bit is set, then it means that the row with the corresponding rowid contains the key value. The internal representation of bitmaps is best suited for applications with low levels of concurrent transactions, such as data warehousing.


    CREATE BITMAP INDEX product_bm_ix
    ON product_information_part(list_price)
    TABLESPACE tbs_1
    LOCAL(PARTITION ix_p1 TABLESPACE tbs_2,
    PARTITION ix_p2,
    PARTITION ix_p3 TABLESPACE tbs_3,
    PARTITION ix_p4,
    PARTITION ix_p5 TABLESPACE tbs_4 );


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact