Invention Grant
- Patent Title: Predicting index fragmentation caused by database statements
-
Application No.: US15171408Application Date: 2016-06-02
-
Publication No.: US10552399B2Publication Date: 2020-02-04
- Inventor: Guy le Mar
- Applicant: QUEST SOFTWARE INC.
- Applicant Address: US CA Aliso Viejo
- Assignee: QUEST SOFTWARE INC.
- Current Assignee: QUEST SOFTWARE INC.
- Current Assignee Address: US CA Aliso Viejo
- Agent Maschoff Brennan
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F16/2453

Abstract:
Systems and techniques for determining a total predicted index fragmentation associated with executing a structured query language statement are described. An execution plan associated with the structured query language statement may be determined. A plurality of tables estimated to be affected by execution of the structured query language statement may be determined. For individual tables, an estimated number of rows that the structured query language statement is to affect may be determined. A predictive model, such as a support vector machine, may be used to determine, for individual tables whose indexes are estimated to be affected, a predicted change in an average index fragmentation percentage associated with individual indexes on the affected tables. The sum of the predicted change in the average index fragmentation percentage of affected indexes may be determined to determine the total predicted index fragmentation associated with executing the structured query language statement.
Public/Granted literature
- US20170351721A1 PREDICTING INDEX FRAGMENTATION CAUSED BY DATABASE STATEMENTS Public/Granted day:2017-12-07
Information query