SQL statements should be written in such a way that the following aims for the processing of an SQL statement are achieved when a search strategy is selected:
The search strategy that is selected is largely dependent upon the form of the
search condition specified in the SQL statement. The search strategy is also selected so that the costs for the processing of the SQL statement are minimized.For more detailed information about the selection of the search strategy, see the following sections:
You can display the search strategy used for an SQL statement with the help of the
EXPLAIN statement.