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.
