Invention Grant
- Patent Title: Automated suspension and rebuilding of database indices
-
Application No.: US15933877Application Date: 2018-03-23
-
Publication No.: US10423606B2Publication Date: 2019-09-24
- 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
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/23

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
- US20180218028A1 AUTOMATED SUSPENSION AND REBUILDING OF DATABASE INDICES Public/Granted day:2018-08-02
Information query