Limiting cursor size

[Erik Mueller-Harder]

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?

Thanks!

Erik