Entering content frame

Background documentation Search Conditions for Inverted Columns Locate the document in its SAP Library structure

If you specify search conditions for inverted columns, the search strategy is determined by the system as specified in the table.

Search Condition

Search Strategy

Equality condition for all inverted columns

Only those rows whose keys are contained in the associated inversion list are accessed.

IN condition for inverted columns

The system accesses the rows whose keys are contained in the inversion lists.

Range Conditions

There is only one condition ( <, <=, >, >=) for one of the two range limits (upper or lower limit).

The system accesses the rows whose keys are contained in the inversion lists that were determined by the range.

Range conditions

Both range limits are specified. It is irrelevant to the selection of the search strategy whether this specification is made using a BETWEEN operator or using two conditions ( <= or >=) for the same column linked by AND.

The system accesses the rows whose keys are contained in the inversion lists that were determined by the range.

In the case of the equality/IN conditions and the range conditions, there are also queries for which it is not necessary to access the rows, as all required values are contained in the inversion list(s).

See also:

Examples: Search Conditions for Inverted Columns

 

 

Leaving content frame