IN Reverse key indexes the values are stored in reverse format..
The advantage of reversekey index will be
1 It is good for inserts where say primary key is comign in sequence. ..
2 It is used where there is lot of concurrency .. useful in rac where there is lot of contention
3) Also rebuilts not need to be done on reverse key index
4) It is not useful for range scan
The following site has good notes and more details on it
http://users.telenet.be/oraguy.be/reverse_key_indexes.htm
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment