Valid For

GLOBALS

Description

Use the DDLRULEHINT parameter to add a RULE hint to the DDL trigger. For example you can add the RULE (/*+NO_UNNEST*/) hint to improve the performance of the trigger when performing SQL queries.

You can also use the define _ddl_rule_hint parameter in the params.sql file to add a hint. For example: define _ddl_rule_hint = '/*+NO_UNNEST*/'

Default

None

Syntax

DDLRULEHINT hint_syntax

hint_syntax

The syntax of the hint. Spaces are not permitted within the hint syntax.

Example

DDLRULEHINT /*+NO_UNNEST*/