首页 > 其他 > 详细

052-175

时间:2017-12-15 11:34:08      阅读:220      评论:0      收藏:0      [点我收藏+]

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()达到

052-175

原文:http://www.cnblogs.com/Babylon/p/8042127.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!