Background processing to provide automated database query tuning

A non-transitory computer-readable medium having stored thereon instructions that, when executed by one or more processors, are configurable to cause the one or more processors to:

• receive, with a computing platform having one or more processors coupled with at least one physical memory device, a request comprising at least a database query at a first time when a database is in a first state, the database query having an associated query identifier (ID);
• analyze the database query with the one or more processors to determine whether the database query has one or more corresponding physical resource requirements that fall within a historical top number of database queries in terms of usage of one or more pre-selected physical resources by checking a query cache storing queries above a pre-selected threshold of consumption of physical resource usage;
• store at least the database query for later query tuning activity if the database query falls within the historical top number of database queries in terms of usage of one or more pre-selected physical resources;
• execute, with the one or more processors, the database query against the database in the first state;
• generate, with the one or more processors and asynchronously with respect to the executing of the database query, one or more query tuning recommendations for one or more stored database queries that fall within the historical top number of database queries in terms of consumption of physical resource usage;
• provide, via a user interface, threshold selectivity input data for tables to which the one or more query tuning recommendations have been generated;
• receive, via the user interface, input to initiate creation of at least one custom index based on the one or more query tuning recommendations;
• execute, with the one or more processors, a subsequent database query modified according to at least one of the query tuning recommendations against the database.

A system comprising:

• at least one memory device;
• one or more processors coupled with the at least one memory device, the one or more processors to execute code configurable to receive, with a computing platform having one or more processors coupled with at least one physical memory device, a request comprising at least a database query at a first time when a database is in a first state, the database query having an associated query identifier (ID), to analyze the database query with the one or more processors to determine whether the database query has one or more corresponding physical resource requirements that fall within a historical top number of database queries in terms of usage of one or more pre-selected physical resources by checking a query cache storing queries above a pre-selected threshold of consumption of physical resource usage, to store at least the database query for later query tuning activity if the database query falls within the historical top number of database queries in terms of usage of one or more pre-selected physical resources, to execute, with the one or more processors, the database query against the database in the first state, to generate, with the one or more processors and asynchronously with respect to the executing of the database query, one or more query tuning recommendations for one or more stored database queries that fall within the historical top number of database queries in terms of consumption of physical resource usage, to provide, via a user interface, threshold selectivity input data for tables to which the one or more query tuning recommendations have been generated, to receive, via the user interface, input to initiate creation of at least one custom index based on the one or more query tuning recommendations, to execute, with the one or more processors, a subsequent database query modified according to at least one of the query tuning recommendations against the database.