Re: Bulking up loops

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 8 Jan 2005 18:58:17 -0000
Message-ID: <01a401c4f5b4$03b309c0$6702a8c0@Primary>

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_at_sbcglobal.net> To: "oracle-l" <oracle-l_at_freelists.org> 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 Received on Sat Jan 08 2005 - 12:53:29 CST