Re: Tuning

"O.C." <clubmitglied_at_yahoo.com> 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.

If the CBO is working well, number 1 should almost always be as fast or faster. Otherwise, number 2 may be faster (by orders of magnitude). Use #1. If that causes major problems, then (get a DBA to) tune the query. If that fails (or you can't wait for an overworked DBA to get around to helping you), try #2.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB