Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning

Re: Tuning

From: O.C. <clubmitglied_at_yahoo.com>
Date: Thu, 12 Dec 2002 22:35:54 +0100
Message-ID: <atavm6$lgp$1@newsread1.arcor-online.net>


Of course i can run tests to get an answer. But i want more : i want arguments.
Why (-arguments pls- ) could the 2. solution be faster ... in which cases.

"Galen Boyer" <galenboyer_at_hotpop.com> schrieb im Newsbeitrag news:uisxz4wro.fsf_at_hotpop.com...
> On Mon, 9 Dec 2002, 100.176512_at_nexgo.de wrote:
> > Hi ! What is faster in embedded SQL (in PRO-C): 1. One join of 5
> > large tables or 2. Splitt the this big SQL into 3-4 parts (and use the
> > output of one sql result as bind variables for the next sql statement)
>
> I don't know, but I could probably test it if I was working on your
> database.
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Thu Dec 12 2002 - 15:35:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US