Alexandre Benson Smith wrote:

>
>>J> How about limiting the number of fetches?
>
> what could be done to stop a long query that returns few records ?
>

Fetches are internal page requests - whether satisfied from cache or
requiring a read from disk. Records returned, reads, and fetches are
different metrics.


Regards,


Ann