Hint - Database Property (Magic xpa 4.x)
Some RDBMSs such MSSQL allow hinting the optimizer for processing a query. Using a Hint String, the developer can specify a hard-coded string that will be concatenated to the SELECT statement as is, without being checked.
It is recommended that you use the Optimizer Hints in special cases only. A full list of the optimizer hints that can be sent to MSSQL or Oracle can be found in MSSQL or Oracle documentation.
Specifying FORCE_ INDEX Hint in the Database Properties dialog box applies to all the indexes in all the data sources in the database.
The syntax of a Hint is:
/*+ Oracle Hint */.
Relevant interfaces: MSSQL and Oracle
SQL Considerations
How Do I Affect the Database Optimizer Behavior?
