Does TiDB support parallel queries?

Translated
1

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

Original topic: tidb 支持并行查询么？

| username: jarry_618

Is there a parallel query feature in TiDB similar to Oracle?

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

TiDB is a distributed database, inherently supporting multi-node parallel queries.

3
| username: xfworld | Original post link

Must support it.

4
| username: 人如其名 | Original post link

The default settings already let you enjoy it, do you still feel it’s not fast enough? :smiley:

5
| username: TiDBer_pkQ5q1l0 | Original post link

It is originally a parallel query.

6
| username: 胡杨树旁 | Original post link

Supports this syntax, tried it.

7
| username: jarry_618 | Original post link

What I am asking is if there is a hint similar to /*+ parallel */ that can consume CPU more extremely to achieve faster speed.

8
| username: jarry_618 | Original post link

The previous answers defaulted to parallelism. Let me address this all at once: OceanBase is also a distributed database that supports parallel hints. With parallel hints, the speed can be increased several times, but of course, the cost is a significant CPU consumption. It is suitable for specific scenarios.

9
| username: Running | Original post link

It is inherently a distributed parallel query database.

10
| username: 人如其名 | Original post link

By default, if the data volume is large, there will be significant CPU consumption. Additionally, TiDB’s parallelism is at the operator level, which can easily amplify the load. This should be taken into consideration during usage.