OCP question

[tomate]

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

[vinay]

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

[gee]

Agree with Vinay.

[tomate]

Thank you, i think as you but i'm not sure.

Thanks

[anjali]

yes, it is Reverse key index, i got this question in A&A exam , i recently passed.

[sudarshan]

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