Specifies if data in a SQL - SELECT statement is based on buffered data or data written to disk.

SET SQLBUFFERING ON | OFF

Parameters

ON

Specifies that the SQL - SELECT statement uses local buffered data if available. If data is not buffered, then data from disk is used.

OFF

(Default) Specifies that the SQL - SELECT statement uses data from disk.

Remarks

See Also