Entering content frameBackground documentation Search Condition Locate the document in its SAP Library structure

Search conditions (<Structure linksearch_condition>) are often specified in SQL statements. However, not all of the search conditions that can be entered are used by the Optimizer to determine an optimal search strategy, but rather only a few of these possible search conditions. To be able to write optimal SQL statements, you should have a detailed knowledge of the search conditions that can be evaluated by the Optimizer.

The search conditions that the Optimizer can use to determine the optimal search strategy are the following:

If the search conditions in an SQL statement cannot be converted into one of the forms listed above, they cannot be used when selecting a search strategy.

The order of search conditions that are linked by equal Boolean operators has no influence on the selection of a search strategy.

If you use UPDATE statements, you can only use the search conditions with restrictions (Search Conditions for UPDATE Statements).

Leaving content frame