Preface
Purpose
Using ABL documentation
References to ABL compiler and run-time features
References to ABL data types
Typographical conventions
Examples of syntax descriptions
Long syntax descriptions split across lines
Complex syntax descriptions with both required and optional elements
Example procedures
OpenEdge messages
Obtaining more information about OpenEdge messages
Database triggers
Trigger definition
ABL database events
Schema and session database triggers
Best practices for ABL triggers
Database Index Usage
Finding out which indexes are used
Maintaining indexes through ABL
Using the ABL ASSIGN statement
Indexes and unknown values
Examples
Indexes and case sensitivity
How ABL chooses and brackets indexes to satisfy queries
Background and terminology
Case 1: WHERE searchExpr
Case 2: WHERE searchExpr AND searchExpr
Case 3: WHERE searchExpr OR searchExpr
General rules for choosing a single index
Bracketing
Searching without index
When TABLE-SCAN is recommended instead of WHOLE-INDEX
When TABLE-SCAN is not recommended to be used
Index-related hints
Preface
Index-related hints