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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center