Re: Bulking up loops
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 8 Jan 2005 18:58:17 -0000
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
