Ansicht
Dokumentation

dbs/ora/use_hints - Generierung von Optimizer Hints bei Oracle

dbs/ora/use_hints - Generierung von Optimizer Hints bei Oracle

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : dbs/ora/use_hints |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description : Generation of Optimizer hints for Oracle |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| The parameter determines whether hints for the cost based optimizer |
| are generated for certain kinds of SQL statement, or |
| not. |
| |
| Parameter value 0 means that no optimizer hints are generated. |
| Hints are usually generated for other values. |
| The values '1' / '-1' activate hints in accordance with standard |
| parameterization. You can also specify in detail |
| when one of the supported hints |
| is to be genenerated, or passed to the |
| database . |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Application area: Database |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit : -1/1/0/ Hint detail specification as described below. |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: -1 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: SAP |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Restrictions on database systems: Oracle |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Are other parameters affected or dependent: No |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
| |
| In the detailed form, the parameter consists of individual |
| components, separated with ",". The format of each sub-specification |
| is "<name> -> <number>", where:
| o "abap -> 0/1" |
| In ABAP programs for open SQL statements, specified hints are |
| either ignored or passed to the database. |
| o "dbif -> 0/1" |
| The SAP database interface analyzes hints entered for open SQL |
| statements to determine if entries were made that can be analyzed |
| by the interface itself. These entries are either ignored |
| or analyzed. |
| o "upto -> <number>"
| A FIRST_ROWS hint is generated, when the SQL statement |
| generated by the SAP database interface contains a condition |
| for the virtual ROWNUM field. In addition, an UPTO limit must be |
| set for the database statement. A SELECT SINGLE implicitly sets |
| the limit to 1. |
| o The value "0" switches off the generation of the corresponding |
| hints. |
| o For each SQL statement, multiple ABAP hints can be generated, and |
| a FIRST_ROWS hint can also be generated. |
| |
| The above short forms correspond to the following details: |
| o 'use_hints = -1' or 'use_hints = 1' |
| -> 'abap->1,dbif->1,upto->[MAXINT]'
| -> All hints are activated. |
| o 'use_hints = 0' |
| -> 'abap->0,dbif->0,upto->0'
| -> All hints are deactivated |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : Generierung von Optimizer Hints bei Oracle
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : S
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------


ROGBILLS - Synchronize billing plans   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 7173 Date: 20240329 Time: 115108     sap01-206 ( 5 ms )