SQL hint Tiflash not effective

Translated
1

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

Original topic: SQL hint Tiflash不生效

| username: TiDBer_pkQ5q1l0

[TiDB Usage Environment] Production
[TiDB Version] v5.2.1
[Encountered Problem]
Want to make SQL use Tiflash for queries, but found that the Hint is not effective.
[Problem Phenomenon and Impact]
The SQL is as follows:

image
image699×483 7.69 KB

Execution Plan:
image
image1903×847 17.6 KB

2
| username: ddhe9527 | Original post link

Try using the MySQL client with the --comments option.

3
| username: TiDBer_pkQ5q1l0 | Original post link

Got it, thanks.

4
| username: xiaohetao | Original post link

:+1::+1::+1:

5
| username: system | Original post link

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