dbs/ora/use_hints - Generierung von Optimizer Hints bei Oracle
PERFORM Short Reference RFUMSV00 - Advance Return for Tax on Sales/PurchasesThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| 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 |
------------------------------------------------------------------------
up to two additional hints can be generated: FIRST_ROWS and
independent of that RULE or USE_CONCAT. The test for usability
tests RULE then USE_CONCAT.
| |
| The above short forms correspond to the following details: |
| o 'use_hints = -1' |
| -> 'abap->1,dbif->1,rule_in->0,rule_fae->0,concat_fae->0,u
-> All hints are deactivated except for open SQL hints.
| o 'use_hints = 0' |
| -> 'abap->0,dbif->0,rule_in->0,rule_fae->0,concat_fae->0,u
| -> All hints are deactivated |
| o 'use_hints = 1' |
| -> 'abap->1, dbif->1, rule_in->10, rule_fae->1, concat_fae-&g
| upto->[MAXINT]' |
| -> Open SQL hints are activated, a RULE hint is generated for large |
| IN clauses and for FOR ALL ENTRIES statement. A FIRST ROW hint |
is generated for ROWNUM statements.
------------------------------------------------------------------------
------------------------------------------------------------------------
| 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 :
------------------------------------------------------------------------
TXBHW - Original Tax Base Amount in Local Currency ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 8264 Date: 20120525 Time: 164910 triton ( 23 ms )
