DTP removes Oracle hints from SQL statement ? [message #584557] |
Fri, 09 March 2007 22:40 |
Mustafa Ahamed Messages: 7 Registered: July 2009 |
Junior Member |
|
|
Hi,
We are noticing that the Oracle hints we supply in the select statements
are being ignored by DTP and hence the query takes long time to execute.
Client : BIRT 2.1.1
Oracle : Oracle 10g
If we write a following sql statement in the BIRT dataset editior
'Select /*+ NO_MERGE_HASH(..) */ Product_id, ...... '
At the time of report execution these hints are removed from the sql
statements. We verified this through Oracle Enterprise Manager and
confirmed that DTP doesnt submit with the hints. We also verified the BIRT
log to make sure that BIRT doesnt strip out these comments.
Has anyone seen this problem before ? Is this a known issue ? Is there any
workaround for this? Any help is highly appreciated.
Thanks
Mustafa
|
|
|
Powered by
FUDForum. Page generated in 0.01641 seconds