Results 1 to 4 of 4

Thread: bitmap indexes

  1. #1
    Join Date
    Dec 2003
    Location
    India
    Posts
    7

    Unanswered: bitmap indexes

    Can I use a bitmap index on colums which get updated daily.
    I have a Oracle 8i db(DSS)

    Regards,
    Mohit

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    no,

    Bitmap indexes are suitable for static data. Creating bitmap Index on updatable data affects the dtabase performance.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    sorry, I did not red that you have mentioned DSS.

    You can do one thing. you can disable indexes before updates and re-enables after finish of updates ( I mean Bulk updates thats how it works in DSS).
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  4. #4
    Join Date
    Dec 2003
    Location
    India
    Posts
    7
    Thanx Bhavin.

    If enable the bitmap index after completing the updates does it take a lot of time for it to get updated when I re-enable it.
    OR
    Can I drop the index before the load and then recreate it


    Originally posted by Hings
    sorry, I did not red that you have mentioned DSS.

    You can do one thing. you can disable indexes before updates and re-enables after finish of updates ( I mean Bulk updates thats how it works in DSS).

Posting Permissions

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