Predictive database index modification

A computer program product comprising:

• a computer readable storage medium readable by one or more processing circuit and storing instructions for execution by one or more processor for performing a method comprising:
• receiving by a database system transaction data from client computer devices, the transaction data defined by insert query data;
• changing a structure of an index of a certain table of the database system in response to the receiving;
• generating index logging data in response to the receiving of the transaction data;
• providing using the index logging data prediction specifying data, the prediction specifying data specifying one or more page generation change predicted to occur with respect to the index;
• and
• modifying the index in dependence on the prediction specifying data.

A system comprising:

• a memory;
• at least one processor in communication with the memory;
• and
• program instructions executable by one or more processor via the memory to perform a method comprising:
• receiving by a database system transaction data from client computer devices, the transaction data defined by insert query data;
• changing a structure of an index of a certain table of the database system in response to the receiving the transaction data, wherein the changing the structure of the certain table of the database system in response to the receiving the transaction data includes adding a page to the index of the certain table in response to the receiving the transaction data;
• generating logging data in response to the receiving of the transaction data;
• providing using the logging data prediction specifying data, the prediction specifying data specifying one or more change predicted to occur with respect to the index;
• and
• modifying the index in dependence on the prediction specifying data.