Re: Doing a query with string vs bind variables.

From: joel garry <joel-garry_at_home.com>
Date: Thu, 20 Sep 2007 15:58:25 -0700
Message-ID: <1190329105.277663.50490@q3g2000prf.googlegroups.com>

On Sep 19, 1:31 pm, Luch <DarthL..._at_gmail.com> wrote:

> The only thing that puzzles is that why, when using the bind-variable
> query from both PowerBuilder and Oracle SQL Developer... It only
> performed poorly from PowerBuilder. Using the bind-variable query from
> Oracle SQL Developer (or SQL Plus) performed the same (and used same
> index) as the string version, even with the outdated statistics.

Also see http://tkyte.blogspot.com , look for subjects like Tuning with sql_trace=true...

Sometimes it can get confusing when there is a dependency on what exactly has run before, even by someone else.

--
@home.com is bogus.
Bludney Plud says "It's GREAT to consume!"
http://www.signonsandiego.com/uniontrib/20070920/news_1b20nbc.html

Received on Thu Sep 20 2007 - 17:58:25 CDT