The difference between a query with NOFILTER clause is that a file will be created on disk (or memory, if you have enough) to hold on the sql results. When the SQL command directs the result "to cursor", and memory is enough, the results stay in it, the query is very quickly.

Hope this help you, Vin.