SET SQLBUFFERING Command

  • Article

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.

See Also

Reference

SET Command Overview
SELECT - SQL Command
SELECT - SQL Command - WITH Clause