Re: Tuning

"O.C." 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)
>
> Indexes are in use.
>
> Thank you !

Running EXPLAIN PLAN. There are too many variables for even an educated guess.

Dan Morgan Received on Mon Dec 09 2002 - 17:02:31 CST