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 !

One join of 5 tables is almost always going to be faster than splitting into separate statements.

That said there are a huge number of variables related to the SQL, the data, the tables, the indexes, the optimizer, etc. that affect SQL statements.

Rather than asking this question what you should do is run a test of two to five different possible solutions using EXPLAIN PLAN in SQL*Plus. And, of course, always use bind variables in any SQL.

Dan Morgan Received on Thu Dec 12 2002 - 10:47:19 CST