OCP question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: OCP question

  1. #1
    Join Date
    Mar 2001
    Posts
    188
    Hello,

    Can you help me please.
    Which Index Type should be created that the variation for updating the Index Tree is the best.

    Answers:

    B* Index Tree
    Bitmap Index
    Reverse Key Index
    Function based Index.

    Thank you for the help

    So long
    Thomas Schmidt
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    9
    If you'r question is
    which Index should you use, so as to spread update across entire index tree ?
    Then the answer for this is Reverse Key Index

  3. #3
    Join Date
    May 2001
    Location
    Victoria, BC Canada
    Posts
    183
    Agree with Vinay.

  4. #4
    Join Date
    Mar 2001
    Posts
    188
    Thank you, i think as you but i'm not sure.

    Thanks
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  5. #5
    Join Date
    Oct 2001
    Posts
    38
    yes, it is Reverse key index, i got this question in A&A exam , i recently passed.

  6. #6
    Join Date
    Aug 2001
    Location
    mumbai
    Posts
    22
    Reverse key index . Answer seems to be B tree index in normal case where leafs(index entries ) are distributed across but as it mentions optimum level of the variation of leafs on updation , reverse key is answer .
    Regards
    Sudarshan

Posting Permissions

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


Click Here to Expand Forum to Full Width