Invention Grant
- Patent Title: Adding entries to an index based on use of the index
- Patent Title (中): 根据索引使用索引添加条目
-
Application No.: US13207954Application Date: 2011-08-11
-
Publication No.: US08396858B2Publication Date: 2013-03-12
- Inventor: Randy L. Egan , Roger A. Mittelstadt , Brian R. Muras
- Applicant: Randy L. Egan , Roger A. Mittelstadt , Brian R. Muras
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Owen J. Gamon
- Main IPC: G06F17/30
- IPC: G06F17/30
Abstract:
In an embodiment, a threshold value is calculated for a current entry in a first column of an index. If the current entry has been read a number of times by execution of an execution plan that is more than the threshold value and the current entry points to at least one row in a table and not all of the at least one row have been selected by the execution plan for inclusion in a result set as satisfying a query that the execution plan implements, then a new entry is added to the index.
Public/Granted literature
- US20130041887A1 ADDING ENTRIES TO AN INDEX BASED ON USE OF THE INDEX Public/Granted day:2013-02-14
Information query
