Which SQL statement bypassess the table buffer?
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.