> > There is no way for the backend to know this, thus imho the app needs
> > to give a hint. 
> 
> Right.  So what do you think about a hint that takes the form of a SET
> variable for the fetch percentage to assume for a DECLARE CURSOR?

Since we don't have other hints that are embedded directly into the SQL
that sounds perfect. 

The not so offhand question for me is whether to use this percentage for 
non cursor selects also. Imho both should (at least in default) behave the same.

Andreas

Reply via email to