发明授权
US07930296B2 Building database statistics across a join network using skew values
有权
使用偏斜值在连接网络上构建数据库统计信息
- 专利标题: Building database statistics across a join network using skew values
- 专利标题(中): 使用偏斜值在连接网络上构建数据库统计信息
-
申请号: US12105754申请日: 2008-04-18
-
公开(公告)号: US07930296B2公开(公告)日: 2011-04-19
- 发明人: Brian Robert Muras
- 申请人: Brian Robert Muras
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Wood, Herron & Evans, LLP
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
An apparatus and program product that build column statistics utilizing at least one skew value. The column statistics built using skew values, instead of column statistics built only through random sampling, may be used to more accurately reflect skew values across join networks, and thus enable a query optimizer to better select an access plan that is optimal under current runtime conditions.
公开/授权文献
信息查询