SQL Optimizer will not optimize a query with nested views. When the original query has a hint with global table references, it will not add to the existing hint--it strips the hint and applies only what hints it knows. It does not currently use global table hints. Global table hints allow the query to be optimized without changing nested views. Is there an option to support global table hints?
Optimizer does not support global table hints.
Enhancement request ST61643 has been submitted to Development for consideration in a future release of SQL Optimizer for Oracle.