Character

SYS(3054) returns the current Rushmore optimization level setting as a character string to the active screen or to a memory variable.

The showplan output displays the table alias as reference for table name.

Use SYS(3054) to improve query performance by determining the extent to which the query is optimized by Rushmore technology.

Issue SYS(3054, 1) to display the Rushmore filter optimization level after a query is executed. The filter optimization level is displayed in the active window.

The following table lists the three levels of Rushmore optimization:

If SYS(3054,1) indicates that a query could not be optimized or could be optimized only partially, you can modify the query to take advantage of Rushmore optimization.

Issue SYS(3054, 11) to display the Rushmore join optimization level after a query is executed. The optimization level is displayed in the active window.

Issue SYS(3054, 0) to stop display of the Rushmore optimization level after a query is executed.

For more information about Rushmore technology and optimizing queries, see Using Rushmore Query Optimization to Speed Data Access.

Reference

Concepts