Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > SAVE EXTERNAL DIRECTIVES >

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. If you specify more than one directive, separate them 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.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]