How to add database hint in ADHOC VIEW

[mrachakonda]

Hello All,

I am new to Jaspersoft and currently work in product support in my organization. Working on solving a tuning a query. I have query which i have tuned using some database hint

SELECT /*+ HINT */  DIMENTION1 , DIMENTION2, FACT1,FACT2,FACT3 FROM TABLE 1, TABLE 2 WHERE < > AND  ETC ETC.

This query is working fine. But when same query used to build report in the Jaspersoft it is not taking hint because in the adhoc view the query which is build and running is 

 

SELECT DIMENTION1 , DIMENTION2 , SUM(FACT1), SUM(FACT2), SUM(FACT3) FROM

(  SELECT /*+ HINT */  DIMENTION1 , DIMENTION2, FACT1,FACT2,FACT3 FROM TABLE 1, TABLE 2 WHERE < > AND  ETC ETC.

)

My questios in how can i add /*+ HINT */  in the top select statement. Please help me out. Thanks a lot.