H.1.1 Types of SQL Hints

Profitability Management supports four types of SQL hints.

• Filter On Hint: A hint inserted into the FILTER_ON_HINT column will be applied to the SELECT query on the allocation's source table (Ledger Class Table, Instrument Table, or Transaction Summary Table).

  Note:

  Effective with release 8.0.5, hints are also supported for Management Ledger tables.
• Tree Filter Hint: For an allocation rule, using a Hierarchy Filter, the hint text specified in the TREE_FILTER_HINT column is applied to sub-selects from the OFSA_IDT_ROLLUP table.
• Percent Distribution Hint: A hint inserted to the PERCENT_DIST_HINT column is applied to the SELECT statement that acquires driver data for Dynamic Driver allocation rules.
• DML Hint: A hint inserted into the DML_HINT column is applied to DML operations that insert into or update target tables, as, Debit or Credit operations. Note that hints that specify database parallelism for DML operations will be ineffective unless you have enabled DML parallelism in FSI_PARALLEL_PARAMETERS. For more information, see Profitability Management Parallel Execution.