Optimizer Ignoring the Hints
(Doc ID 405088.1)
Last updated on JANUARY 23, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
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.
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