Code Inspector: Bypassing of table buffer, IN lists

[] [] [] [] [] [] []

Symptom

If IN lists are used in the WHERE condition, the check “SELECT Statements That Bypass the Table Buffer” in the Code Inspector issues the message “Generically Buffered Key Area not Completely Specified for Table &1″. However, none of the buffered key fields of the table with an IN condition is accessed, in other words, the buffer can be used.
Other terms

SCI, bypassing buffer
Reason and Prerequisites

Implementing Note 1313226 (Code Inspector: IN lists for table buffer workaround) or importing the relevant Support Package has changed the way in which IN lists and OR clauses are handled in connection with a bypassing of the table buffering. For this, the following was ignored: Only if the buffered key fields of a table with generic or single record buffering are compared with an IN list, the table buffer can be bypassed.
Solution

To correct this problem, implement this note. However, implement this note only after you implemented the note mentioned above.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment