Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which SQL statement bypassess the table buffer?

buffer sql Table
0
Posted

Which SQL statement bypassess the table buffer?

0

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.

Related Questions

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.