Results 1 to 4 of 4

Thread: Bit Map Index

  1. #1
    Join Date
    Jan 2002
    Posts
    11

    Unanswered: Bit Map Index

    Is there a concept of Bitmap index in DB2 UDB ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Bit Map Index

    DB2 Optimizer builds bitmap indexes dynamically when it 'feels' that an index of this type will be more economical to process the query ...

    HTH

    Cheers

    Sathyaram


    Originally posted by RVenkatraman
    Is there a concept of Bitmap index in DB2 UDB ?

  3. #3
    Join Date
    Jan 2002
    Posts
    11
    Thanks for the Prompt response.

    Could you please confirm whether the Dynamic Bitmap Indexing feature is available on UDB 7.2 EE or is it specific to EEE

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I believe that this feature is a general db2 thing ...

    The chapter in Admin guide that gives a hint on bitmap index is 'Understanding the SQL Compiler' ... As far as I see, it is a general discussion and not specific to a product ....



    Originally posted by RVenkatraman
    Thanks for the Prompt response.

    Could you please confirm whether the Dynamic Bitmap Indexing feature is available on UDB 7.2 EE or is it specific to EEE

Posting Permissions

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