• Configuration name -The name of the configuration this queue is to be used in. For details, see Queue Configurations.

• Maximum number of concurrent queries allowed to execute at a time.

• Maximum time (clock time) allowed for a query to wait in the wait list before running. This may mean the queue temporarily exceeds its normal maximum number of concurrent queries. This prevents low priority queries from waiting indefinitely.

• A read/write restriction - A queue can be configured as read, write, or read-write. A read queue can queue only select queries. A write queue can queue only queries with non-select statements (such as inserts, updates, deletes, drops). A read-write queue can queue any query.

• A priority (critical, high, medium, low) that allows the system to define which queues have execution priority over other queues. Lower priority queues can be configured to only use a (user specified) fraction of the resources used by higher priority queues. For more information, see Queue Ratios.

• A ratio number - When specified, the ratio number is used to determine the ratio of resource use between this queue and higher priority queues. For more information, see Queue Ratios.