Patent ID: 11971890
Assignee: OCIENT HOLDINGS LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A database management system comprising:
a processing circuit that includes a processor that operates in conjunction with a memory to create an initial execution plan of a query;
a first query optimizer configured to be executed by the processor utilizing the initial execution plan as input to generate a first execution plan for the query; and
a second query optimizer that is distinct from the first query optimizer, configured to be executed by the processor concurrently with execution of the first query optimizer utilizing the initial execution plan as input to generate a second execution plan for the query;
wherein the processor is configured to select a first lowest cost execution plan from the first execution plan and the second execution plan;
wherein the first query optimizer is further configured to be executed by the processor utilizing the first lowest cost execution plan as input to generate a third execution plan for the query, wherein the second query optimizer is further configured to be executed by the processing circuit utilizing the first lowest cost execution plan as input to generate a fourth execution plan for the query, and wherein the processing circuit is configured to select a second lowest cost execution plan from the first lowest cost execution plan, the third execution plan, and the fourth execution plan.