发明名称 |
Collecting statistics in a database system |
摘要 |
Statistics regarding at least one attribute (or column) of a table in a database system are collected using an enhanced mechanism for faster collection. The statistics collection is based on scanning a sample of rows of a given table, with the sample being less than all the rows of the table. The percentage of rows to be read is specified in a statement submitted to the database system. The database system then uses the specified percentage to read the sample rows from the table for collecting statistics on the at least one attribute.
|
申请公布号 |
US6801903(B2) |
申请公布日期 |
2004.10.05 |
申请号 |
US20010976634 |
申请日期 |
2001.10.12 |
申请人 |
NCR CORPORATION |
发明人 |
BROWN DOUGLAS P.;CHAWARE JEETENDRA |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|