Invention Grant
US07930296B2 Building database statistics across a join network using skew values
有权
使用偏斜值在连接网络上构建数据库统计信息
- Patent Title: Building database statistics across a join network using skew values
- Patent Title (中): 使用偏斜值在连接网络上构建数据库统计信息
-
Application No.: US12105754Application Date: 2008-04-18
-
Publication No.: US07930296B2Publication Date: 2011-04-19
- Inventor: Brian Robert Muras
- Applicant: Brian Robert Muras
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Wood, Herron & Evans, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30
Abstract:
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.
Public/Granted literature
- US20080228709A1 BUILDING DATABASE STATISTICS ACROSS A JOIN NETWORK USING SKEW VALUES Public/Granted day:2008-09-18
Information query
