Optimizer hint added at block level is not used for COUNT_QUERYon the block.

Hi all,

we are using forms 10g and 11g r2 DB.

I am having a performance issue with the view based on which database block is build on the form.

on adding the choose hint to the query it is giving be quick output.

i have used below code to set optimizer hint property on the forms pre-query trigger.

Set_Block_Property('DeptBlock',OPTIMIZER_HINT,'CHOOSE');

and use message(:system.last_query);  to view the query to check if the hint is added or not.

it is working fine at the time of execute query. but incase of count_query it is not woking