Server Properties

There are a number of properties that are settable in the SQL Engine. They do not need to be changed unless the behavior of the system must be modified. The properties are set using the following SQL syntax:

    SET property = value;

The value can be one of three types depending on the property: numeric, boolean or string. A boolean value is either an integer-0 is false, anything else is true-or one of the following strings: "on", "off", "true", "false", "yes" or "no".

The settings are grouped as follows:

• Search and optimization parameters
• Metamorph parameters
• Rank knobs
• Other ranking properties
• Indexing properties
• Locking properties
• Miscellaneous Properties