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 -> Tuning

Tuning

From: O.C. <clubmitglied_at_yahoo.com>
Date: Mon, 9 Dec 2002 19:40:22 +0100
Message-ID: <3df4e45d$0$20118$9b4e6d93@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 Mon Dec 09 2002 - 12:40:22 CST

Original text of this message

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