申请试用
HOT
登录
注册
 
使用变体索引改进查询性能

使用变体索引改进查询性能

Andy
/
发布于
/
1973
人观看
The read-mostly environment of data warehousing makes it possible to use more complex indexes to speed up queries than in situations where concurrent updates are present. The current paper presents a short review of current indexing technology, including row-set representation by Bitmaps, and then introduces two approaches we call Bit-Sliced indexing and Projection indexing. A Projection index materializes all values of a column in RID order, and a Bit-Sliced index essentially takes an orthogonal bit-by-bit view of the same data. While some of these concepts started with the MODEL 204 product, and both Bit-Sliced and Projection indexing are now fully realized in Sybase IQ, this is the first rigorous examination of such indexing capabilities in the literature.
15点赞
5收藏
0下载
相关推荐
确认
3秒后跳转登录页面
去登陆