|
Data Retrieval bypassing SAP DB buffer |
|
|
|
|
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:
|
