Guidelines for Defining Queries

Poorly structured queries cause memory and performance problems. For example, the result of a query might be so large that the computer system depletes resources to handle the result. Other queries might consume more processing time than they should.

These topics contain practices and guidelines for improving query execution and performance.

Where Clause Guidelines
Criteria Based on Evaluating Values Against the Execution of a Program Object
Indexed Attributes and Basics
Processing Relational Expressions
Searching Based on Lengthy String Fields
Using .value
Using .isset
Query Syntax
Query Parsing
Selects and Macros in Where Clauses
Searching on Date/Time
Creating Sets to Search
Using Const for Reserved Words
Invalid Where Clauses
Modeling Considerations
Avoiding Unbounded Queries and Large Expands
Object Existence
Query Instantiation
Nested Queries