Yes, and for a good reason: the hint relation has exactly the same scope with other elements of queries/sub-queries.
Suppose there's a query like: select /*+ broadcast(s) */ from (select a, b from s) t join (select a, b from t) s on t1.a = t2.b If we allowed the hint resolving to "cross" the scopes, we'd end up with a really confusing spec. Thanks, Maryann On Tue, Jun 11, 2019 at 5:26 PM John Zhuge <jzh...@apache.org> wrote: > Hi Reynold and Maryann, > > ResolveHints javadoc indicates the traversal does not go past subquery > alias. Is there any specific reason? > > Thanks, > John Zhuge >