Run SQL Scripts in debug mode

Running your SQL script in debug mode allows you to see query optimizer messages and other database debugging messages. You can also view these messages in Visual Explain by including them in Run SQL Scripts.

To run your SQL script in debug mode:

  1. Open Run SQL Scripts.
  2. If you want to see query optimizer messages and other database debugging messages, select Include Debug Messages in Job Log before running the statements.
  3. After the statements are run, select Job log from the View menu to view the debug messages.