SAP Parameter dbs/ora/substitute_literals - global setting for openSQL hint SUBSTITUTE_LITERALS


Short text
global setting for openSQL hint SUBSTITUTE_LITERSame behavior as the OpenSQL pseudo hint SUBSTITUTE_LITERALS,but with global validity (that is, for every statement)

  • 1 ==<(>><)> Literals are always transferred to the Oracle Shared Pool as
  • they are, they are never replaced with host variables.(-<(>><)> for Optimizer purposes)
    • 0 ==<(>><)> Default behavior:
    • Literals are replaced by host variables unless the pseudo hintSUBSTITUTE_LITERALS is used in the SQL statement.

      Work area

      { 0, 1 }