Optimizer: SAP DB 7.4
Factors that Influence the Processing of an SQL Statement
Runtime Improvement for SQL Applications
Search Condition
Equality Condition
Area Condition
IN Condition
LIKE Condition
Search Strategy
Sequential Search
Search Conditions for Key Columns
Search Conditions for Inverted Columns
Examples: Search Conditions for Inverted Columns
Search Conditions for UPDATE Statements
Cost Determination
Search Conditions Linked with OR
Postponement of the Search to the FETCH Time
Join
List of All Search Strategies
CATALOG KEY ACCESS
CATALOG SCAN
CATALOG SCAN USING USER EQUAL CONDITION
DIFFERENT STRATEGIES FOR OR-TERMS
EQUAL CONDITION FOR INDEX
EQUAL CONDITION FOR INDEX (SUBQ)
EQUAL CONDITION FOR KEY COLUMN
EQUAL CONDITION FOR KEY COLUMN (SUBQ)
IN CONDITION FOR INDEX
IN CONDITION FOR KEY COLUMN
JOIN VIA INDEXED COLUMN
JOIN VIA KEY COLUMN
JOIN VIA KEY RANGE
JOIN VIA MULTIPLE INDEXED COLUMNS
JOIN VIA MULTIPLE KEY COLUMNS
JOIN VIA RANGE OF MULTIPLE INDEXED COL.
JOIN VIA RANGE OF MULTIPLE KEY COLUMNS
NO RESULT SET POSSIBLE
NO STRATEGY NOW (ONLY AT EXECUTION TIME)
RANGE CONDITION FOR KEY COLUMN
RANGE CONDITION FOR KEY COLUMN (SUBQ)
RANGE CONDITION FOR INDEX
RANGE CONDITION FOR INDEX (SUBQ)
INDEX SCAN
TABLE SCAN
EXPLAIN Statement
EXPLAIN Statement for Joins
EXPLAIN Statement for Complicated SELECT Statements
EXPLAIN Statement for SELECT Statements with Subqueries
EXPLAIN Statement: Columns O,D,T,M
Terms and Examples
Inverted Column
Inversion List
Examples
example
ind
indf
invcolumn1
invcolumn2
one
ten1
ten2