Warning: include_once(http://erpgenie.com/_borders/topabap.htm) [function.include-once]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /var/www/vhosts/erpgenie.com/httpdocs/abaptips/templates/rhuk_solarflare_ii/index.php on line 52

Warning: include_once() [function.include]: Failed opening 'http://erpgenie.com/_borders/topabap.htm' for inclusion (include_path='.:') in /var/www/vhosts/erpgenie.com/httpdocs/abaptips/templates/rhuk_solarflare_ii/index.php on line 52

Login

Login to view more content!!!





Lost Password?
No account yet? Register

Registered Access

Poll

What area of ABAP are you interested in?
 
Home arrow Tips and Tricks arrow ABAP Reports arrow Data Retrieval bypassing SAP DB buffer
Data Retrieval bypassing SAP DB buffer PDF Print E-mail
User Rating: / 1
PoorBest 
Written by Anon.   
Tuesday, 13 March 2007
Some extensions / versions of the SELECT statement don't support usage of SAPs internal database buffer.  This causes additional unnecessary database accesses. Here's a list of all this statements:
  • Usage of SELECT FOR UPDATE
  • Usage of ORDER BY  with sort sequence differing from the primary key
  • Usage of SELECT COUNT(*)
  • Usage of aggregate functions (AVG, MAX, MIN, SUM)
  • Elimination of duplicates (DISTINCT)
  • Conditions for IS [NOT] NULL
  • Usage of SELECT SINGLE without specifying complete primary key in WHERE condition
  • Usage of GROUP BY or HAVING clauses
  • Usage of Subqueries
  • Usage of Joins
  • Usage of Native SQL


Related Items:

 
< Prev   Next >

Google Search

Statistics

Contribution Activity
Utilities: 38
Tips and Tricks: 333
Sample Code: 164
Total Contributions: 550

Member Activity
Members: 6244 since 2/1/2007!
New: 1 since yesterday!
Visitors: 1077577

Newest Members

Welcome our newest members:

Google Ads


Warning: include(http://erpgenie.com/_borders/bottom.htm) [function.include]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /var/www/vhosts/erpgenie.com/httpdocs/abaptips/includes/footer.php on line 22

Warning: include() [function.include]: Failed opening 'http://erpgenie.com/_borders/bottom.htm' for inclusion (include_path='.:') in /var/www/vhosts/erpgenie.com/httpdocs/abaptips/includes/footer.php on line 22