1. A database management system (DBMS) comprising: a memory for storing computer executable instructions; and a processing unit for accessing the memory and executing the computer executable instructions, the computer executable instructions comprising: a query optimizer to: generate a query plan for a query received at a query input; and determine an estimated resource execution cost of the query plan, the estimated resource execution cost comprises a plurality of estimated cost fields; a compiler to hold the query the holding prevents the query from executing based on a determination that the estimated resource execution cost of the query plan exceeds at least one of a plurality of cost rules, wherein the estimated resource execution cost is based on at least one of a number of join operations and a number of cross product operations in the query plan for executing the query; wherein the cost rules comprise: a fixed cost threshold; and a variable cost threshold; and the estimated cost comparison is based on a comparison between the plurality of estimated cost fields and the fixed cost threshold and the variable cost threshold of the cost rules; and wherein the query held at the compiler is prevented from executing for a given time period, the time period including one of an off-peak period, a low priority period, and an indefinite period.
1. A database management system (DBMS) comprising: a memory for storing computer executable instructions; and a processing unit for accessing the memory and executing the computer executable instructions, the computer executable instructions comprising: a query optimizer to: generate a query plan for a query received at a query input; and determine an estimated resource execution cost of the query plan, the estimated resource execution cost comprises a plurality of estimated cost fields; a compiler to hold the query the holding prevents the query from executing based on a determination that the estimated resource execution cost of the query plan exceeds at least one of a plurality of cost rules, wherein the estimated resource execution cost is based on at least one of a number of join operations and a number of cross product operations in the query plan for executing the query; wherein the cost rules comprise: a fixed cost threshold; and a variable cost threshold; and the estimated cost comparison is based on a comparison between the plurality of estimated cost fields and the fixed cost threshold and the variable cost threshold of the cost rules; and wherein the query held at the compiler is prevented from executing for a given time period, the time period including one of an off-peak period, a low priority period, and an indefinite period. 9. The DBMS of claim 1 , wherein a query requestor submits the query received at the query input such that the query requestor requests that the query be executed.