Syntax options:

    COMPLIANCE MANDATORY | COMPLIANCE OPTIONAL

    Specifies the compliance level for this outline.

    MANDATORY indicates that all outline directives such as table
    order and index usage should be followed as specified. If the
    optimizer is unable to follow any outline directive, an exception
    is raised.

    OPTIONAL indicates that all outline directives are optional and
    that if they cannot be followed, no exception should be raised.
    If OPTIONAL is specified, the strategy chosen by the optimizer
    to carry out the underlying request may not match the strategy
    specified within the outline.

    Use MANDATORY when the strategy that the optimizer chooses must
    be followed exactly as specified from version to version of
    Oracle Rdb even if the optimizer finds a more efficient strategy
    in a future version of Oracle Rdb.

    The default is COMPLIANCE OPTIONAL.