dbs/ora/use_hints SAP Parameter attribute - Generierung von Optimizer Hints bei Oracle

dbs/ora/use_hints is a SAP Parameter attribute which is used to control Generierung von Optimizer Hints bei Oracle information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

dbs/ora/use_hints profile paramerter attributes

Parameter Name: dbs/ora/use_hints
Description: Generierung von Optimizer Hints bei Oracle
Default Value: -1
Parameter Type ( See IF_PARAMETER_TYPES): String(STRING)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-ORA
System-Wide parameter: No
Dynamic Parameter: No
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

The parameter determines whether hints for the cost-based optimizer are generated for certain types of SQL statement. Parameter value 0 means that no optimizer hints are generated. Hints are usually generated for other values. The values '1' / '-1' activate hints according to standard parameterization. You can also specify in detail, as a parameter, when one of the supported hints is to be generated or passed to the database.

See SAP Parameter Documentation for full SAP documentation for this profile parameter.