Invention Grant
- Patent Title: Automated suspension and rebuilding of database indices
-
Application No.: US14477924Application Date: 2014-09-05
-
Publication No.: US10025814B2Publication Date: 2018-07-17
- Inventor: Michael Bender , Wayne M. Delia
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Maeve M. Carpenter; Isaac J. Gooshaw
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Embodiments of the present invention disclose a method, computer program product, and a computer system for suspending a database index. A computer determines if an update to a database includes an update to an index of the database. If so, the computer suspending the index of the database, wherein the suspending the index of the database comprises: the computer deleting the index of the database; the computer retaining a definition for the index of the database, wherein the definition includes a command for rebuilding the index of the database; and the computer indicating in a system catalog of the database that a status of suspension has been applied to the index.
Public/Granted literature
- US20160070746A1 AUTOMATED SUSPENSION AND REBUILDING OF DATABASE INDICES Public/Granted day:2016-03-10
Information query