Optimizer Ignoring the Hint USE_NL(A,B) in 19c
(Doc ID 2883208.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
19c Optimizer Ignoring the Hint If using as mentioned below.
Select /*+ ORDERED USE_NL(A,B) */ ........
We do see these lines from Execution Plan.
U - USE_NL(A,B) / rejected by IGNORE_OPTIM_EMBEDDED_HINTS >>>>
13 - SEL$A75CC17B / B@SEL$1
U - USE_NL(A,B) / rejected by IGNORE_OPTIM_EMBEDDED_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 |