984714 wrote:Which indicates that it is likely that something is wrong with your tests or your assumptions.
One more information, the issue doesn't happen on Oracle 11g
984714 wrote:Well, the difference between the Prepared and normal Statement is simply that Oracle has determined that that line there is always true so the plan will simply ignore it for the non-bound query.
_'uddi:systinet.com:soa:model:taxonomies:contractAgreementStates' = 'uddi:systinet.com:soa:model:taxonomies:contractAgreementStates'_ is the reason that cause slow performance. This condition is not necessary. However, i cannot remove it because the query is generated automatically.
Edited by: 984714 on Jan 29, 2013 11:26 PM