Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please Help DB Buffer Cache Size
What I was referring to is the fact your cursor can be replaced by
a single statement, using count() and max().
Something that was hinted earlier in this thread, when statistical
functions (max()...) were mentioned.
Such a statement would be many, many times more effective, and faster,
than any cursor construct.
And, in case you did not read aloud:
for all elements returned in my cursor,
add the outcome of the cursor to the accumulated outcome. end loop.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Aug 18 2005 - 03:09:44 CDT
![]() |
![]() |