EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Reference User Guides Quick Start
  • Product
    EDB Backup and Recovery Tool EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Connectors EDB Postgres Containers EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Data Adapter EDB Postgres JDBC Connector EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres .NET Connector EDB Postgres OCL Connector EDB Postgres PgBouncer EDB Postgres Replication Server PostgreSQL pgAdmin 4

EDB Postgres Advanced Server → 11 → User Guides → Database Compatibility for Oracle® Developer’s Guide
Other versions of this page: 12 · 11 · 9.5 · 9.4

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

Table of Contents Previous Next


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

Table of Contents Previous Next
© 2019 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks