Limiting cursor size

[Charles Yeomans]

On Thursday, June 12, 2003, at 09:04 AM, Erik Mueller-Harder wrote:

> It's probably staring me in the face, but I cannot find the answer to 
> this in the documentation.
>
> Is there a way to limit the size of a cursor?  Often, I find I'm 
> interested in only the first row or two in a cursor that might have a 
> few hundred rows in it -- and I'd like to tweak things so I don't 
> incur the extra overhead of 100s of rows.
>
> I guess I'm thinking something like:
>
>     SELECT FIRST foo, bar from myBO WHERE foo = 'some value'
>
> Can this be done?  Or in fact are cursors so well fine-tuned that 
> there'd be no performance benefit anyway?

I don't believe that data is retrieved from disk until you actually 
call for the specific record, so I think that you're okay as you are.

Charles Yeomans