SYS(3092) - Output Rushmore Query Optimization Level

  • Article

Specifies a file to which Rushmore optimization levels for queries are output.

SYS(3092 [,cFileName [, lAdditive]])

Parameters

  • cFileName
    The name of the file to which the Rushmore optimization levels are output.

    Specify the empty string ("") to turn off output and close a file created earlier with this function.

  • lAdditive
    A logical value that specifies if the file is overwritten when a new query is executed.

    If lAdditive is set to true (.T.), the query optimization levels are appended to previous output.

    If lAdditive is set to false (.F.) (the default setting), any previous output is overwritten.

Return Value

SYS(3092) returns the empty string if Rushmore optimization levels for queries are not being output to a file. If query optimization levels are being output to a file, SYS(3092) returns the path and name of the file to which output is directed.

Remarks

Use SYS(3054) - Rushmore Query Optimization Level to specify the type of Rushmore optimization information that is sent to the output file.

SYS(3092) is scoped to a thread in a multithreaded runtime application. Both SYS(3092) and SYS(3054) are unavailable in the OLE DB Provider for Visual FoxPro.

See Also

Tasks

How to: Optimize Filters and Joins

Reference

SYS(3054) - Rushmore Query Optimization Level