If a statement includes two or more conflicting hints, the server ignores the conflicting hints. The following table lists the hints that are conflicting with each other.

Hint Conflicting hints
ALL_ROWS FIRST_ROWS - all formats
FULL(table) INDEX(table [ index ])

PARALLEL(table [ degree ])

INDEX(table) FULL(table)


PARALLEL(table [ degree ])

INDEX(table index) FULL(table)

NO_INDEX(table index)

PARALLEL(table [ degree ])

PARALLEL(table [ degree ]) FULL(table)



USE_HASH(table) NO_USE_HASH(table)
USE_MERGE(table) NO_USE_MERGE(table)
USE_NL(table) NO_USE_NL(table)