Select Single with Full buffering

[Former Member]

Hi,

I know that when we use single buffering in a table, if we don't use select single then it'll bypass the buffer and directly hit database. But what will happen if we use select single with full buffering? Will it bypass the buffer?

Thanks,

Sarif

[Former Member]

Hi,

I know that when we use single buffering in a table, if we don't use select single then it'll bypass the buffer and directly hit database. But what will happen if we use select single with full buffering? Will it bypass the buffer?

Thanks,

Sarif

[retired_member]

See SAP Buffer -Restrictions ...

Only accessing a table with single buffering with a SELECT where the key is not fully specfied bybasses the buffer.

Using SELECT SINGLE for a fully buffered table does not bypass the buffer.

In fact, since 7.02 it is not the addition SINGLE but only the key specification that counts.

(see Modification 2, the documentation for single buffering is misleading and needs to be corrected - thanks to your question).

B.t.w., see also