CURSOR LOOPS in PL/SQL
From: SyonOCPAD <syonNOsySPAM_at_perigee.net.invalid>
Date: Wed, 19 Apr 2000 10:14:11 -0700
Message-ID: <0139fce0.10ee388a_at_usw-ex0102-084.remarq.com>
[Quoted] I have a hypothesis I want validated or invalidated. Which is faster performance wise?
A) CURSOR FOR LOOP
B) SIMPLE LOOP with CURSOR
Date: Wed, 19 Apr 2000 10:14:11 -0700
Message-ID: <0139fce0.10ee388a_at_usw-ex0102-084.remarq.com>
[Quoted] I have a hypothesis I want validated or invalidated. Which is faster performance wise?
A) CURSOR FOR LOOP
B) SIMPLE LOOP with CURSOR
My arguement lies with (B) --> (A) uses an explicit cursor but [Quoted] [Quoted] forces Oracle to handle the cursor implicitly. We all know to avoid using implicit cursors because of the inherent double fetch and the overhead put on Oracle to allocate the cursor variable, open, fetch, and close the cursor.
Does anyone have the definitive answer?
My test runs on 87,000 rows loop is that (B) is faster by
approximately 3 seconds.
Anyone?
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * [Quoted] The fastest and easiest way to search and participate in Usenet - Free!