New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Improvement]Support table index in complex query hint #3403

Closed

PanternBao opened this issue Sep 5, 2022 · 1 comment

Assignees

Labels

Milestone

Member

PanternBao commented Sep 5, 2022 •

edited

Loading

can use query hint as follows：

/*!dble:plan=1 & 2 & 3 )$use_table_index*/ select * from t1 a left join t2 b on a.id = b.id left join t3 c on a.id=c.id

1 is a, 2 is b, 3 is c

PanternBao added this to the 3.22.07.0 milestone

PanternBao added the Improvement label

PanternBao assigned yanhuqing666

yanhuqing666 closed this as completed

Member Author

PanternBao commented Sep 5, 2022

updated doc：https://github.com/actiontech/dble-docs-cn/blob/develop/2.Function/2.33_execute_plan_hint/overview.md#hint%E8%AF%AD%E6%B3%95

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment