Conflicting hints v17
If a command includes two or more conflicting hints, the server ignores the contradicting hints. The following table lists hints that contradict each other.
| Hint | Conflicting hint |
|---|---|
ALL_ROWS | FIRST_ROWS - all formats |
FULL(table) | INDEX(table [ index ])PARALLEL(table [ degree ]) |
INDEX(table) | FULL(table)NO_INDEX(table)PARALLEL(table [ degree ]) |
INDEX(table index) | FULL(table)NO_INDEX(table index)PARALLEL(table [ degree ]) |
PARALLEL(table [ degree ]) | FULL(table)INDEX(table)NO_PARALLEL(table) |
USE_HASH(table) | NO_USE_HASH(table) |
USE_MERGE(table) | NO_USE_MERGE(table) |
USE_NL(table) | NO_USE_NL(table) |