Answer Posted / shreeshaildiggi
SAP buffering :
Buffering of data from database tables defined in a table
buffer in the shared memory of the current application
server. The definition determines whether and how a
database table is buffered. Buffering generally leads to
greatly enhanced performance (by a factor of between 50 and
500) and is administrated by the database interface.
Buffering usually becomes effective when Open SQL commands
are used for database access. However, some variants do not
use the buffering process.
The following Open SQL statements implicitly bypass the SAP
buffer and access the database tables directly:
SELECT with the addition FOR UPDATE,
Access to a table using single-record buffering without
selecting a single record using SINGLE SELECT or by
specifying the primary key in the WHERE condition (this
behavior depends on the current implementation of the
database interface and may be different in future
releases).
SELECT with the addition DISTINCT,
SELECT with aggregate expressions,
Open SQL statement with the addition CLIENT SPECIFIED,
without specification of the client ID in a WHERE
condition,
SELECT with JOIN expressions
Access to a generically buffered area without full
specification in a WHERE condition
Open SQL statements with IS [NOT] NULL in the additions
WHERE and HAVING,
Use of a subquery in a WHERE condition,
SELECT with the addition GROUP BY,
SELECT with the addition ORDER BY, whereby the sort key is
not the primary key.
Thanks and Regards
SHREESHAIL DIGGI
SAP Technical Consultant Infinite India
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the other modules integrated with om? : sap abap hr
how to capture the errors in bdc Call transaction method?
wht is the diff. b/n initialization and lotus of event
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
What are the tcodes for performance tuning?
What does the ‘suppress dialog’ do?
hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp
What are the parameters used in each function?
How do you set up background jobs in sap? What are the steps? What are the events driven batch jobs?
Explain lsmw?
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
What is a table pool?
What is elementary search help? : sap abap data dictionary
How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?
How can cluster table be created?
