Re: Can this query go faster???

Joost Kraaijeveld schrieb:
> Hi Tino,
>
..
>
>>Cursor would work too but you would need to have a persistent connection.
>
> I just tried it: a cursor is not faster (what does not surprise me at
> all, as the amount of work looks the same to me)

Actually no, if you scroll forward, you just ask the database for the
next rows to materialize. So if you are ahead in your database and
ask for next rows, it should be faster then working w/ an offset
from start each time.