Selecting access flow path in complex queries

A system comprising:

• a processor;
• and
• a computer-readable storage medium communicatively coupled to the processor and storing program instructions which, when executed by the processor, are configured to cause the processor to:
• build a classification model configured to identify a lowest cost access path;
• receive a query, wherein the query is configured to retrieve a set of data from a database;
• generate an access map for the query, wherein the access map includes one or more potential access paths to execute the query;
• collect, for the query, a set of data for each potential access path;
• classify, by the classification model, the query;
• select a first access path of the one or more potential access paths;
• and
• execute the query.

A computer program product, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processing unit to cause the processing unit to:

• build a classification model configured to identify a lowest cost access path;
• receive a query, wherein the query is configured to retrieve a set of data from a database;
• generate an access map for the query, wherein the access map includes one or more potential access paths to execute the query;
• collect, for the query, a set of data for each potential access path;
• classify, by the classification model, the query;
• select a first access path of the one or more potential access paths;
• and
• execute the query.