Re: Tuning

From: Bert Bear <bertbear_at_NOSPAMbertbear.net>
Date: Tue, 10 Dec 2002 07:42:41 GMT
Message-ID: <RVgJ9.2420$7P4.1302343774@newssvr11.news.prodigy.com>

I take this is NOT a SQL question but an OCI (PRO*C, SQL/REXX, etc.) tuning issue.

#1 is your answer from an OCI (Pro*C, SQL/REXX, etc.) tuning prespective.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

"O.C." <clubmitglied_at_yahoo.com> wrote in message news:3df4e45d$0$20118$9b4e6d93_at_newsread2.arcor-online.net...
> 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)
>
> Indexes are in use.
>
> Thank you !
>
>
>
Received on Tue Dec 10 2002 - 01:42:41 CST