2.4.8 Conflicting Hints

Other Resources

Download Postgres
Free Postgres Training
Webinar: Exploring 10 Postgres Tips and Tricks

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

Try it Now Free

2 SQL Tutorial : 2.4 Optimizer Hints : 2.4.8 Conflicting Hints

2.4.8 Conflicting Hints

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.

Table 2‑4 Conflicting Hints

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)

2 SQL Tutorial : 2.4 Optimizer Hints : 2.4.8 Conflicting Hints

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)