US 12,242,479 B1
Automatic index recommendations for improved query performance
Yu Ma, Xi'an (CN); Jing He, Xi'an (CN); Fu-qiang Lv, Xi'an (CN); Haotian Zhou, Xi'an (CN); and Xiaotao Wang, Xi'an (CN)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jan. 31, 2024, as Appl. No. 18/428,740.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) 20 Claims
OG exemplary drawing
 
1. A system comprising:
at least one memory that stores instructions; and
one or more processors configured by the instructions to perform operations comprising:
identifying a plurality of candidate indexes associated with a database query that is classified as a slow query;
generating, for each candidate index of the plurality of candidate indexes, a feature vector representing statement features and statistical features associated with the candidate index;
providing the feature vectors to one or more machine learning models to obtain, for each candidate index of the plurality of candidate indexes, an index recommendation value;
causing presentation, at a user device, of an index recommendation that identifies a first index of the plurality of candidate indexes, the first index being identified in the index recommendation based at least partially on the index recommendation value obtained for the first index;
receiving user input indicative of a user selection of the first index; and
in response to receiving the user input, automatically updating a database schema to include the first index.