What are the methods for ensuring stable execution plans in TiDB?

Translated
1

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

Original topic: TiDB稳定执行计划的方法有哪些

| username: alfred

【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed that led to the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: buddyyuan | Original post link
  1. The best method is binding, binding the execution plan.
  2. Secondly, you can disable automatic statistics updates to prevent changes in the statistics.
3
| username: db_user | Original post link

Binding is the most stable, but lower versions need to pay attention to the impact of character sets and collation.

4
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.