|Removing Oracle hints [message #222750]
||Tue, 06 March 2007 22:28
Originally posted by: ybarkalov.yahoo.com|
I'm developing report and using a lot of Oracle hints like MATERIALIZE,
NO_MERGE and USE_HASH() for performance reasons. And it seems that BIRT
strips out ALL the hints when executing this query. At least Oracle
Enterpise Manager shows SQL without any hits at all. And execution plan
that it chooses also matches to the query with hits striped out. And with
all the hints gone, the query never completes with execution path chosen
The same query runs fast from SQL Plus and other client tools. The
execution plan is exactly as hints define it. And the execution plan is
different from the one shown in Enterpise Mananger for BIRT session.
Is this the standard behavoir for BIRT to remove hints? Is there a way to
leave hits in the query?
Powered by FUDForum
. Page generated in 0.02735 seconds