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:
- Open Run SQL Scripts.
- If you want to see query optimizer messages and other database debugging messages, select Include Debug Messages in
Job Log before running the statements.
- After the statements are run, select Job log from the View
menu to view the debug messages.