Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain the difference between tables and structures?
what is difference between set screen and call screen ?
What will exactly the hide statement do?
What are spa/gpa parameters (sap memory)?
Define abap/4 layer? : abap data dictionary
If I forgot some command in sap script e.g.: Suppress zero display – how to do find it?
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?
What is an abap/4 query? : abap hr
What is tcode se16?
What are the arithmetic operators in the sap abap?
Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?
Give few names of pooled tables in sap ?
Does the call transaction method allow multiple transactions to be processed by sap?
How to combine multiple order in one Delivery ( Step by Step)?
