发明授权
- 专利标题: Collecting statistics in a database system
- 专利标题(中): 在数据库系统中收集统计信息
-
申请号: US09976634申请日: 2001-10-12
-
公开(公告)号: US06801903B2公开(公告)日: 2004-10-05
- 发明人: Douglas P. Brown , Jeetendra Chaware
- 申请人: Douglas P. Brown , Jeetendra Chaware
- 主分类号: G06F1730
- IPC分类号: G06F1730
摘要:
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.
公开/授权文献
- US20030088579A1 Collecting statistics in a database system 公开/授权日:2003-05-08
信息查询