Rewrite Method Directive:
|--NESTED--+----------+-----------------------------------------|
'-comments-'
By default, the database server attempts to unnest correlated subqueries. You can use the NESTED rewrite directive in the outermost query to prevent the query plan from being rewritten with unnested subqueries.
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| comments | Text documenting the directive | Must appear between comment symbols | Character string |