Connor McDonald wrote:
[snip!]
>>
>>What's wrong with an old fashioned cursor?
>>Open it, read - if it fails: no records, if it doesn't: you
>>have one or more records.
>>
>>Requires 1 read.
>>
>>You do not want to know how many, you just
>>want to know if any - so don't use a count.
>>(After Steven Feuerstein)
>>--
>>
>>Regards,
>>Frank van Bortel
>
>
> The only problem with
>
> open cur
> fetch
> close
>
> is that you've given Oracle no information as to the fact that you're
> just doing an existence check. The way to do this would be to add "and
> rownum=1" or the wrapper with dual as previously posted.
>
> hth
> connor
Hmmm - are you suggesting Oracle reads more than I requested?
Let's see what Flavio's tests prove, or elaborate, please.
--
Regards,
Frank van Bortel
Received on Sat Feb 21 2004 - 10:18:08 CST
