My Oracle Support Banner

Optimizer Ignoring the Hints (Doc ID 405088.1)

Last updated on JANUARY 23, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Hints not used by optimizer .

If the SQL query involves several tables and join conditions and if it is required to force the index access/full table access or whatever, hints could be used to accomplish the task.

If the query involves aliases for the tables and the if hints are mentioned with the table name and not with the alias name, then the optimizer wont use the hints.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.