Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Use ABL Database Triggers and Indexes

Database Index Usage

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Database Triggers
    • Trigger definition
    • ABL database events
    • Schema and session database triggers
    • Best practices for ABL triggers
  • Database Index Usage
    • Find out which indexes are used
    • Maintain indexes through ABL
    • Use 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
    • Search without index
      • When TABLE-SCAN is recommended instead of WHOLE-INDEX
      • When TABLE-SCAN is not recommended to be used
    • Index-related hints
Table of Contents

Database Index Usage

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: August 25, 2021
  • 1 minute read
    • OpenEdge
    • Version 12.2
    • Documentation

This topic explains how an OpenEdge application uses indexes.

Contents
  • Find out which indexes are used
  • Maintain indexes through ABL
  • Use the ABL ASSIGN statement
  • Indexes and Unknown values
  • Indexes and case sensitivity
  • How ABL chooses and brackets indexes to satisfy queries
  • Search without index
  • Index-related hints
TitleResults for “How to create a CRG?”Also Available inAlert