Conflicting Hints v12

If a command includes two or more conflicting hints, the server will ignore the contradictory hints. The following table lists hints that are contradictory to each other.

HintConflicting Hint
ALL_ROWSFIRST_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)