ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Overview →  ABAP SQL - Table Buffering →  Table Buffering - Buffering Types 

Table Buffering - Full Buffering

When a row is read, all rows in the table or view are loaded to the table buffer. The buffered table or view is either entirely in the buffer or not at all. In the buffer, the buffered data records are sorted by the key of the table or view. Optimized access requires that the left-justified part of the primary key or of the fields of a secondary index be as large as possible. If not, the buffer is scanned in a linear fashion.

If full buffering is switched on in a client-specific table or view, generic buffering using the client column as a generic key is performed internally.

Other versions: 7.31 | 7.40 | 7.54

Notes

• In a fully buffered table or view, access to nonexistent data is very fast (see Buffer Management).

• Full buffering should be used in small tables, such as customizing tables. In larger tables, full buffering is worthwhile only if large quantities of data are read frequently. Writes on fully buffered tables should be performed only rarely.

Example

The table T005 is fully buffered since it is small and accessed often by reads.