Changing server options temporarily for relational data sources

The SET SERVER OPTION statement overrides the server option value in the server definition for the duration of a single connection to the federated database. The overriding value is not stored in the global catalog.

About this task

For static SQL, using the SET SERVER OPTION statement affects only the execution of the static SQL statement. Using the SET SERVER OPTION statement has no affect on the plans that the optimize generates.

Procedure

To set a server option value temporarily for a relational data source, use the SET SERVER OPTION statement.

Example:

SET SERVER OPTION PLAN_HINTS TO Y' FOR SERVER SYB_SERVER