SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 97 / 271

the performance of the SQL query execution. The SQL Query Rewrite Facility is enabled
by default.
Examples:
Disable SQL Query Rewrite Facility:
execute(reset no_qrwenable) by sasspds; /* Disable query rewrite */
execute(reset _qrwenable=0) by sasspds; /* Another way to disable */
Re-enable SQL Query Rewrite Facility:
execute(reset _qrwenable) by sasspds; /* Re-enable query rewrite */
execute(reset _qrwenable=1) by sasspds; /* Another way to enable */
_QRW Option:
Use the _QRW reset option to enable diagnostic debugging and tracing outputs from the
SQL Query Rewrite Facility in the log. The diagnostic debugging option is disabled by
default.
Examples:
Enable diagnostic debugging function:
execute(reset _qrw) by sasspds; /* Enable diagnostics */
execute(reset _qrw=1) by sasspds; /* Another way to enable */
Disable diagnostic debugging function:
execute(reset no_qrw) by sasspds; /* Disable diagnostics */
execute(reset _qrw=0) by sasspds; /* Another way to disable */
_QRW Option:
91