Specifies if data in a SQL - SELECT statement is based on buffered data or data written to disk.
SET SQLBUFFERING ON | OFF
- Specifies that the SQL - SELECT statement uses local buffered data if available. If data is not buffered, then data from disk is used.
- (Default) Specifies that the SQL - SELECT statement uses data from disk.
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.