Using SQL Mode Diagnostics › Diagnostics Request › Plan Optimization Options

Plan Optimization Options

Display the Plan Optimization Options panel by selecting Plan Optimization Options on the Diagnostics Request panel or by typing PLAN on the command line. Any user authorized to perform diagnostic functions can use this panel. From it, you can specify production of optimization messages, specify join optimization, or display messages.

 =>

 ------------------------------------------------------------------------DQKT0
 DATAQUERY:  PLAN OPTIMIZATION OPTIONS               AUTHID: PUBLIC
 -----------------------------------------------------------------------------
 Select the plan optimization options desired by placing any character in the
 space next to your choice and press PF4 to update your plan options.
 Press PF3 to display existing optimization messages.
 -----------------------------------------------------------------------------
      OPTIMIZATION MESSAGE OPTIONS FOR PLAN NAME  DQxxxxOM
         PREPARATION TIME                    EXECUTION TIME
          _  NO MESSAGES (DEFAULT)            _  NO MESSAGES (DEFAULT)
          _  SUMMARY MESSAGES                 _  SUMMARY MESSAGES
          _  DETAIL MESSAGES                  _  DETAIL MESSAGES

      OPTIMIZATION MODE
          _  MANUAL JOIN ORDER (ORDER LISTED IN "FROM" CLAUSE)
          _  PREPARATION TIME ORDER (DEFAULT)




 -----------------------------------------------------------------------------
 <PF1> HELP      <PF2> RETURN      <PF3> DISPLAY MESSAGES      <PF4> UPDATE