Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

[Dmitry Y. <fir...@ya...>]

20.12.2021 13:58, Dimitry Sibiryakov wrote:
>
> Even non-scrollable cursors can know total number of records if plan 
> SORT is used

Sort may be hidden inside other execution nodes, so it's not always as 
easy to know. I'd rather avoid returning (or not) info depending on the 
query plan.

> or they are fetched to the end

This is surely possible, but is it really needed? The cursor is likely 
to be closed soon, who would need a row count at this point?


Dmitry