Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Which SQL statement bypassess the table buffer?

help me

replied

hi

reward if usefull

Following are the SQL statements which bypass table buffer; avoid these statements when working with buffered tables.

SELECT ... BYPASSING BUFFER.

SELECT from the database views

SELECT ... DISTINCT ... .

SELECT COUNT, SUM, AVG, MIN, MAX.

SELECT ... ORDER BY (other than the primary key)

SELECT ... FOR UPDATE. (EXEC ... ENDEXEC)

Native SQL statements.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question