Assign a resource pool at QUERY runtime

Hello AskV,
Is there a query-level hint that can force the execution engine to begin with a specific resource pool?
- assuming that the query is being executed within a session, which itself has permission to execute in the specified pool

Something like

SELECT /*+pool('PoolB') */
FROM foo... ;

I am aware that we have the option to define the pool at user and session level etc, and I am also aware that we have cascading pools.
I am looking for a method for QueryX to begin immediately in PoolB instead of firstly trying PoolA and then the query always being cascaded to PoolB after Y seconds.
I'm using AlwaysReplan (select set_config_parameter ('CascadeResourcePoolAlwaysReplan',1); ) so I am wasting Y seconds on each execution of QueryX.
If instead I could direct QueryX straight to PoolB, I might shave up to Y seconds from the query run time .

I do not want to define PoolB at session-level or user-level because within the same session, there will be other queries which I am very happy to begin in PoolA

Regards, Mike


Michael Flower
EMEA Vertica Systems Engineer
(M)+44 7793 757 623
Michael.Flower@microfocus.com