052-175

What can you achieve by implementing reverse key index?
A.Reverse the bytes of each column indexed including the row ID.
B.Store a bitmap for each key value instead of a list of row IDs in the leaf node.
C.Prevent contention on the highest leaf block when using sequences to generate keys.
D.Remove repeated key values from the index to fit more index entries in a given amount of disk space.

A 改变的是字符顺序,不是列顺序
B 描述的是 bitmap index
C 正确
D Remove repeated key values 可以尝试用函数索引 substr()达到

posted @ 2017-12-15 11:21  巴啦啦大魔王  阅读(135)  评论(0编辑  收藏  举报