Viewing and Changing VLDB Properties

You can change VLDB properties to alter the syntax of a SQL statement and take advantage of database-specific optimizations.

Modifying any VLDB property should be performed with caution only after understanding the effects of the VLDB settings that you want to apply. A given VLDB setting can support or optimize one system setup, but the same setting can cause performance issues or errors for other systems. Use this manual to learn about the VLDB properties before modifying any default settings.

Some VLDB properties are characterized as "advanced properties": advanced properties are relevant only to certain projects and system configurations. To work with advanced VLDB properties, see Viewing and Changing Advanced VLDB Properties.

To View and Change VLDB Properties

1. Open the VLDB Properties Editor to display the VLDB properties for the level at which you want to work. (For information on object levels, see Order of Precedence.)
2. Modify the VLDB property you want to change. For use cases, examples, sample code, and other information on every VLDB property, see Details for All VLDB Properties.
3. If necessary, you can ensure that a property is set to the default. At the bottom of the Options and Parameters area for that property (on the right), select the Use default inherited value check box. Next to this check box name, information appears about what level the setting is inheriting its default from.
4. Click Save and Close.
5. You must also save in the object or editor window through which you accessed the VLDB Properties Editor. For example, if you accessed the VLDB properties by opening the Metric Editor and then opening the VLDB Properties Editor, after you click Save and Close in the VLDB Properties Editor, you must also click Save and Close in the Metric Editor to save your changes to VLDB properties.