[EMAIL PROTECTED] wrote: > > What does SAP do with the result of a query it has executed? > > Does it use the CACHE (if large enough) to execute it, and > then store the > results in tempory space until the record set is closed?
It depends: if no physically building of the resultset (see EXPLAIN-output) is needed, then only few infos (meta-data) about the resultset are stored in main memory until the resultset is closed. if physically building is needed, temporary space is used, which (depending on the needed space, the space needed for other tasks, the size of the data cache) will be in main memory (data cache) or has to be written to disk. The needed space for meta-data and resultset itself will be cleared when the resultset will be closed implicitly or explicitly. Therefore it is a good habit, to use CLOSE <cursorname> resp. the corresponding methods if a cursor is not needed any more. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
