Hi every one,

Why does this take forever (each query is sub second when done seperately)? 
Is it because I cannot open two cursors in the same transaction?

begin;

declare SQL_CUR01 cursor for 
SELECT A.ordernummer, B.klantnummer FROM "orders" A LEFT OUTER JOIN "klt_alg" B 
ON A.Klantnummer=B.Klantnummer ORDER BY A.klantnummer;
fetch 100 in SQL_CUR01;

declare SQL_CUR02 cursor for 
SELECT A.ordernummer, B.klantnummer FROM "orders" A LEFT OUTER JOIN "klt_alg" B 
ON A.Klantnummer=B.Klantnummer ORDER BY A.klantnummer desc;
fetch 100 in SQL_CUR02;

commit;


TIA

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl 

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to