SQL Query Hints

Query hints are part of the SQL language since Infor Baan 5.0.

The SQL query hints can be divided into three groups:

1. The "no hints" hint:

   If you use the "no hints" hint, the database driver does not generate a hint. Although no database hint is generated, the hint generation will not continue with the other hint origins.

2. Hints that influence the execution tree:

   This group consists of these hints:

   • The first rows and all rows hints.
   • The database dependent string literal hint.
   • The ordered hint.
   • The use index <n> on <table> hint.
3. Hints that influence driver behavior, such as array fetching:

   These hints do not influence the database hint generation in the driver, and are ignored. A hint can be generated based on other SQL hints, if present, or based on one of the other hint origins.