js editor
Web development
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
This SET command is scoped to the current data session. If you want more control at the table level, use the WITH (BUFFERING = ON | OFF) clause in the SQL - SELECT statement. It overrides the SET SQLBUFFERING statement.
You can use SET(“SQLBUFFERING”) to query the current setting.