Enables or disables display of Rushmore optimization levels for queries.
Syntax
SYS(3054, 0 | 1 | 11)
Returns
Character
Arguments
0
(Default) Disables the display of Rushmore optimization levels.
1
Enables the display of the Rushmore filter optimization levels.
11
Enables the display of Rushmore join optimization levels.
Remarks
SYS(3054) returns the parameter you include (0, 1, or 11) as a character string.
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:
| Optimization Level | Description |
| None | The query could not be optimized with Rushmore technology. |
| Partial | Some expressions in the query could be optimized with Rushmore technology. The index tags used for Rushmore optimization are listed. |
| Full | The query was fully optimized with Rushmore technology. The index tags used for Rushmore optimization are listed. |
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 "Understanding Rushmore Technology" in Chapter 15, "Optimizing Applications," in the Programmer's Guide.
For more information about Rushmore technology and optimizing queries, see "Understanding Rushmore Technology" in Chapter 15, Optimizing Applications, in the Programmer's Guide.