Salesforce

Hint - Database Property (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Hint - Database Property (Magic xpa 3.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.

MSSQL

Specifying FORCE_ INDEX Hint in the Database Properties dialog box applies to all the indexes in all the data sources in the database.

Oracle

The syntax of a Hint is:

/*+ Oracle Hint */.

Relevant interfaces: MSSQL and Oracle

Related Topics

How Do I Affect the Database Optimizer Behavior?

Reference
Attachment 
Attachment