7. Using Monitoring and Tracing Tools : Trace Utilities : SET Options for Tracing Queries
 
Share this page                  
SET Options for Tracing Queries
SET options of special interest in query troubleshooting include:
• [NO]PRINTQRY—Set query display on or off.
• [NO]QEP—Set query execution plan display on or off.
• JOINOP [NO]TIMEOUT—Set optimizer timeout on or off.