How to Choose a Distributed Execution Plan in TiDB

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

Original topic: tidb中如何进行分布式执行计划选择

| username: swino

How to choose a distributed execution plan in TiDB

| username: Fly-bird | Original post link

What exactly is the requirement?

| username: 大飞哥online | Original post link

You can’t choose, unless you have deployed the standalone version.
The selectable options are to use tikv or tiflash.

| username: dba远航 | Original post link

Isn’t there a section on optimizing indexes and execution plans in the course? It covers when to use what.

| username: xingzhenxiang | Original post link

Adjusting the SQL, the explain will show whether it uses TiKV or TiFlash.

| username: zhanggame1 | Original post link

You can hint to choose some execution plans, the data is distributed, and the query will definitely be distributed as well.

| username: oceanzhang | Original post link

I didn’t quite understand what you meant.