[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
|
[news.eclipse.dtp] DTP removes Oracle hints from SQL statement ?
|
- From: test@xxxxxxxxxxxx (Mustafa Ahamed)
- Date: Fri, 9 Mar 2007 22:40:17 +0000 (UTC)
- Newsgroups: eclipse.dtp
- Organization: Eclipse
- User-agent: NewsPortal/0.36 (http://florian-amrhein.de/newsportal)
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