Invention Grant
- Patent Title: Automatic database statistics creation
- Patent Title (中): 自动创建数据库统计信息
-
Application No.: US10981799Application Date: 2004-11-05
-
Publication No.: US07289999B2Publication Date: 2007-10-30
- Inventor: Nigel R. Ellis , Rodger N. Kline
- Applicant: Nigel R. Ellis , Rodger N. Kline
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Lee & Hayes, PLLC
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A system for automatic statistics creation comprises a query optimizer which automatically generates statistics derived from data in a database and selects an executable procedure from a plurality of procedures that operate on data in a database using the automatically generated statistics. A counter is maintained of updates made to each statistic that has been automatically generated. If the counter breaches a threshold, the automatically generated statistic is removed from the database.
Public/Granted literature
- US20050108199A1 Automatic database statistics creation Public/Granted day:2005-05-19
Information query