CURRENT OPTIMIZATION PROFILE special register
The CURRENT OPTIMIZATION PROFILE special register specifies the qualified name of the optimization profile to be used by DML statements that are dynamically prepared for optimization.
The initial value is the null value. The value can be changed by invoking the SET CURRENT OPTIMIZATION PROFILE statement. An optimization profile that is not qualified with a schema name will be implicitly qualified with the value of the CURRENT DEFAULT SCHEMA special register.
Example 1: Set the optimization profile to 'JON.SALES'.
SET CURRENT OPTIMIZATION PROFILE = JON.SALES
Example
2: Get the current value of the optimization profile name for
this connection.
VALUES (CURRENT OPTIMIZATION PROFILE) INTO :PROFILE