Re: Bulking up loops

The 10g pl/sql compiler does "loop optimization" of
IMPLICIT cursor for loops by turning them into 
array fetches of size 100 in an outer loop.

There's a one-slide summary in my OW presentation

http://www.jlcomp.demon.co.uk/evolution.html


Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Dec 23rd 2004






----- Original Message ----- 
From: "Mladen Gogala" <gogala@xxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, January 08, 2005 6:48 PM
Subject: Bulking up loops


In a recent article to comp.databases.oracle.server Connor McDonald
hinted that Oracle 10g does automatic bulk loads for "cursor for =20
loops", if coded properly. I wasn't able to find anything about it.
Does anybody here know what Connor is talking about? A pointer to
an article or an example, maybe?

--=20
Mladen Gogala
Oracle DBA


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: