Does TiDB support CBO (Cost-Based Optimization)? If yes, to what extent?

FAQ
1

Yes. TiDB uses the cost-based optimizer. The cost model and statistics are constantly optimized. TiDB also supports join algorithms like hash join and sort-merge join.