Invention Application
- Patent Title: Automatic database statistics creation
-
Application No.: US10982496Application Date: 2004-11-05
-
Publication No.: US20050065911A1Publication Date: 2005-03-24
- Inventor: Nigel Ellis , Rodger Kline
- Applicant: Nigel Ellis , Rodger Kline
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F7/00

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
- US07624094B2 Automatic database statistics creation Public/Granted day:2009-11-24
Information query