The query has been canceled because the estimated cost of this query () exceeds the configured threshold of 1000. Contact the system administrator.
QUERY_GOVERNOR_COST_LIMIT - Is a numeric or integer value specifying the longest time in which a query can run. "Query cost" refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration.
Overrides the currently configured query governor cost limit value for the current connection.
SET QUERY_GOVERNOR_COST_LIMIT 6000
The setting of SET QUERY_GOVERNOR_COST_LIMIT is set at execute or run time and not at parse time.
Note: increasing the query governor cost is not a good solution, we would recommend to pay more attention to sql statement.