International Business Machines Corporation
DYNAMICALLY ALTERING A QUERY ACCESS PLAN

Abstract:

A computer-implemented method dynamically changes an access plan during run-time. The method includes, receiving, from a host, a query, that is configured to retrieve a set of data from a database. The method also includes, generating an access plan, the access plan comprising a plurality of commands. The method further includes, creating, for a first command of the plurality of commands, a plurality of mini plans including a first mini plan and a second mini plan. The method includes, analyzing each mini plan of the plurality of mini plans. The method also includes, changing, dynamically and in response to the analyzing, the access plan.