Re: SQL fast, PL/SQL slow, optimizer confused.

From: Bjorn Augestad <root_at_localhost.com>
Date: Wed, 18 Feb 2004 11:57:31 +0100
Message-ID: <vyHYb.4842$rj4.68409@news2.e.nsc.no>

Stephan Bressler wrote:
> Hi,
>
> pl/sql always uses bind veriables, even explicit values are translated
> into bind variables. This might give the optimizer fewer information
> about the cardinality of the index access.
> Try your explicit query with bind variables.
> Give us the explain plans.
> You can hint oracle to use index accesses by setting
> optimizer_index_cost_adj to 10 and optimizer_index_caching to 90. Might
> have side effects on other queries.
> Stephan
>

Hi,

I've experimented some more since the OP, and it turns out that the hint USE_CONCAT solves my problem. ;-)

Thanks for responding so fast.

Bjørn Received on Wed Feb 18 2004 - 04:57:31 CST