selecting from remote tables

From: <alex_n_at_equinoxlt.com>
Date: Thu, 06 Aug 1998 08:55:06 GMT
Message-ID: <6qbr19$ugq$1@nnrp1.dejanews.com>

Hello
Here is the code I am trying to optimize: for rec in (select * from retek_rag_skus) loop

select style from retek_rag_style where style = rec.style; select something from retek_items_sups_add where style = rec.style; etc...
end loop;

all retek_* tables are on the remote server, and the loop is executing too slowly (5 iterations per second). Any ideas how to optimize it are very wellcome. Btw, exactly the same code will run fine when the remote tables are being simulated on a local server. Indexes are applied on remote tables.

Thanks,
Alex

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 06 1998 - 03:55:06 CDT