{DELETE | SELECT | UPDATE} /*+ */
{DELETE | SELECT | UPDATE} --+
, SQL, , .
, , .
SQL :
- SELECT, UPDATE DELETE;
- ;
- .
( RULE) .
SQL , , , OPTIMIZATION_MODE OPTIMIZATION_GOAL ALTER SESSION (. 4).
/*+ ALL_ROWS */ ( ) ( ), .
/*+ FIRST_ROWS */
( ) ( ), . :
- ;
- - ;
- , ORDER BY.
, , DISTINCT, , .. , , Oracle .
/*+ CHOOSE */ , SQL. .
/*+ RULE */ .
/*+ {FULL | ROWID} () */
ROWID.
/*+ INDEX ( [ ]) */
.
( ) .
:
/*+ ORDERED */ , FROM.
. , , .
|
|
/*+ STAR */ , , .
, , . STAR, , , , , , , .
, .
/*+ {USE_NL USE_MERGE} () */
ORACLE - .
USE_NL USE_MERGE ORDERED. , .
USE_NL , , .. . , .
/*+ {CASH | NOCASH } () */
, .
.
/*+ {MERGE | NO_ MERGE } () */
, ORACLE .
.
ORACLE
EXPLAIN PLAN
, SELECT, UPDATE, INSERT DELETE.
, , . , , . .
EXPLAIN PLAN , .
EXPLAIN PLAN , , . , , .. , .
EXPLAIN PLAN UTLXPLN.SQL , .
|
|
.