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.