1. Administration and Configuration Guide
  2. Rule Run Framework Configurations
  3. Performance Optimization Setting for RRF Module
  4. Use ROWID

Use ROWID

If this is set to Y, ROWID will also be used along with Primary Key in MERGE query. This entry should be made for MERGE execution mode only. This also follows a waterfall model same like execution mode.

  • If Use ROWID is set (as Y/N) in the Optimization table, it will take preference over the Configuration table entry.
  • If Use ROWID is set as N in Optimization table and
    • It is set to Y in Configuration table, for all the rules ROWID will be used, irrespective of what is set in rule level.
    • It is set to N in Configuration table, then it will check for rule level setting and behave accordingly.
  • If Use ROWID is left blank in the Optimization table, it will be considered as N.