The directive Specification
Each directive specification in the SAVE EXTERNAL DIRECTIVES
statement must follow the syntax of the Optimizer Directives segment,
as described in Optimizer Directives,
except that if you specify more than one directive, you must separate
them in the directives list by a blank character, rather than by a
comma ( , ) symbol, as in the following example:
SAVE EXTERNAL DIRECTIVES /*+ AVOID_INDEX (table1 index1)*/ /*+ FULL(table1) */
ACTIVE FOR
SELECT /*+ INDEX( table1 index1 ) */ col1, col2
FROM table1, table2 WHERE table1.col1 = table2.col1;
This example associates AVOID_INDEX and FULL directives with the specified query. The inline INDEX directive is ignored by the query optimizer when the external directives are applied to a query that matches the SELECT statement.