Hello,
When executing the query which returns billions of records, the server-side
cursor holds the records in memory or keeps those in temp-table/file ?
e.g.
select * from LINEITEM order by L_ORDERKEY desc;
Can somebody help me to understand this ?
-Piyush