Page History

...

1. Table names in use_hash hint is required to avoid mistake hint propagation if there are multiple lookup joins. In theory, it's better to support both table names and alias names, but the alias name of subquery or table would not be lost by the sql converter and sql optimizer. So here we only support table names.
2. The hint only provides a suggestion to the optimization, it is not an enforcer.

...