Which SQL statement bypassess the table buffer?
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. • BSEG Access Index tables to provide quicker access to BSEG (Accounting Documents) Choose the index table that best matches the data that you want to retrieve.