| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: count(*) vs. a cursor when determining the existing record on primary key
Originally posted by Sybrand Bakker
> On Fri, 20 Jun 2003 19:18:11 +0000, andrewst
> wrote:
>
> > contrary to
> >the myth so widely believed even by Senior DBAs apparently
> ;)
>
> This has nothing to do with myths, but with reading trace files.
>
>
Very old ones presumably. So how would you explain the result I
obtained (and knew I would obtain) where the SELECT INTO beat the
explicit cursor by about 25%? And if you don't take my word for it, (a)
try it yourself or (b) search AskTom for his more comprehensive
debunking of this MYTH.
-- Posted via http://dbforums.comReceived on Fri Jun 20 2003 - 16:59:48 CDT
![]() |
![]() |