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

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

Andy
/
发布于
/
1900
人观看
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秒后跳转登录页面
去登陆