
> >So I think if you want to make optimization decisions based on cursors
> >being used versus a "normal" select, then the only thing you can safely
> >take into account is the network roundtrip and client processing per
> >fetch, but that might be as random as anything.
> 
> Which is why I like the client being able to ask the 
> optimizer for certain kinds of solutions *explicitly*.

Yes, something like:
	set optimization to [first_rows|all_rows]

Andreas

Tue, 31 Oct 2000 14:14:15 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: LIMIT in DECLARE CURSOR: request for comments