Manual Hints in TiDB

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: Tidb 手工hint

| username: 气死人的萌新

[Test Environment for TiDB]
[TiDB Version] v6.1.0
[Reproduction Path]
[Encountered Issue: The hint verification result is different from the official documentation, as shown in the figure]
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

image
image966×391 11.1 KB

Experimenting with this statement, the result is as follows
image
image941×394 9.92 KB

It used HashJoin instead of IndexJoin. I checked and found that before version V6.4.0, it also used IndexJoin.
image
image878×576 18.3 KB

Very confused, can any expert explain this to a newbie?

2
| username: ShawnYan | Original post link

Could you please send the document link?

3
| username: 气死人的萌新 | Original post link

Use EXPLAIN to View the Execution Plan of JOIN Queries | PingCAP Documentation Center

4
| username: Jasper | Original post link

Try adding --comments when connecting with the MySQL client?

5
| username: 气死人的萌新 | Original post link

I did an experiment, and it worked. Why is that?

6
| username: tidb菜鸟一只 | Original post link

No problem

7
| username: Jasper | Original post link

Because if not added, comments will be excluded by default, meaning the content in the hint will be automatically ignored.

8
| username: ShawnYan | Original post link

The old version of the MySQL client will ignore hints by default, you need to manually add -c.

9
| username: 气死人的萌新 | Original post link

I manually operated it once and found the result was incorrect. I copied and pasted it again, and both results were the same. I don’t know why :sob:

image
image948×610 15.2 KB

10
| username: 气死人的萌新 | Original post link

Thank you, thank you.

11
| username: zhanggame1 | Original post link

Using the command line is overwhelming, better install a tool.

12
| username: 气死人的萌新 | Original post link

I’m using Xshell. Do you have any recommended tools?

13
| username: zhanggame1 | Original post link

You can take a look here.

14
| username: cy6301567 | Original post link

Is this thing easy to use?

15
| username: redgame | Original post link

Sure, please provide the Chinese text you need translated.

16
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.