COF-C02 · Question #683
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
The correct answer is B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS. The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait…
Question
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Options
- ASTATEMENT_TIMEOUT__IN__SECONDS
- BSTATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- CMAX_CONCURRENCY__LEVEL
- DQUERY_TIMEOUT_IN_SECONDS
How the community answered
(19 responses)- A5% (1)
- B95% (18)
Explanation
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue.
Topics
Community Discussion
No community discussion yet for this question.