Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Tuning
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